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 |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2010-10-15 : 14:57:12
|
| Hi All, Need small help with a query...I have a table with two columnscol1 col21 p1 q1 r2 x2 yNow i want the output as col1 col21 p,q,r2 x,ycould anyone please let me know how i can do this? there should be no temp tables in the script because i am going to use this in the front end. This is in SQL 2000. so no use of cross apply. Any help would be highly appreciated.Thanks in Advance. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Combine two records of a column