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 |
|
jeff06
Posting Yak Master
166 Posts |
 Posted - 2007-11-20 : 08:46:43
|
| My table also have a id colume, thanksThe sql ret is in t1.id date col1 col21 11/1/07 2 32 11/2/073 11/5/074 11/6/075 11/7/076 11/8/077 11/9/078 11/12/07----20 11/19/07I want tranpose it to t2id 1 2 3 4 5 6 7 ---------------- 20date 11/1/07 11/2/07 11/5/07 11/6/07 11/7/07 11/8/07 11/9/07-11/12/07Q1 2Q2 3How can i do that?I do not have right to create a procedureThanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-20 : 09:06:12
|
Do you have to do this in SQL Server ? Presentation and formatting of the data should be done at the front end
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
table transpose in query analyzer 2000