Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 17:56:56
|
Martin writes "Dear sir/ madam,
I really need the query which can combine a column into a variable.
Here's an example:
Studenttable
===============================
| ID | Class | Name |
===============================
| 1 | 1a | John |
-------------------------------
| 2 | 1a | May |
-------------------------------
| 3 | 1a | Wayne |
-------------------------------
| 4 | 1b | Brian |
-------------------------------
After executing the query I want as result:
[1a, John May Wayne]
[1b, Brian]
Please send your reply to mlam@casema.net, thanks.
Martin Lam" |
|
|
|
|
|
Need a SQL query for concatenating a single column.