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 |
|
jparker
Posting Yak Master
118 Posts |
 Posted - 2006-02-20 : 05:12:16
|
| HelloI would like to turn the following number of rows in a table 7 | 1234567898 | 12345678911 | 1234567894 | 9999999995 | 999999999into the following output via a select statement7, 8, 11 | 1234567894, 5 | 999999999I can do this with a temporary table and a loop but wondered if there were something more efficient out thereThanks in advanceJP |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jparker
Posting Yak Master
118 Posts |
Posted - 2006-02-20 : 05:30:06
|
| thank you very helpful |
 |
|
|
|
|
|
Multiple lines into one