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 |
|
joanne
Starting Member
46 Posts |
 Posted - 2010-12-06 : 17:50:24
|
| Hello, I have a table with 2 columns:No SerialNumber123 4GB6Y78123 53F7TH124 4GB6Y78124 53F7TH124 53E8BXthe question is :how to get the results as following:123 4GB6Y78 53F7TH124 4GB6Y78 53F7TH 53E8BX...125 with 6 columns....etc...Thank you very much! |
|
|
sql-programmers
Posting Yak Master
190 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
rows to columns