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 |
|
anishmm
Starting Member
2 Posts |
 Posted - 2007-09-18 : 07:53:04
|
| hii have one table X------------------------------------------A B C D1 2 3 42 3 4 53 4 5 6------------------------------------------I want the result is ---------------------------------------------A 1 2 3B 2 3 4C 3 4 5 D 4 5 6---------------------------------------------How can i get this answer ?any one know this answer pls send me answerregars anish mm |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-18 : 08:37:58
|
1) Are you using SQL Server 2005 or SQL Server 2000?2) Are there more columns in the table, such as an IDENTITY?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
anishmm
Starting Member
2 Posts |
Posted - 2007-09-18 : 09:01:40
|
| hithanks for Replay vary fast I am using SQL 2000Table has no DENTITY columnRegards, Anish mm |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Column to Row