Groups | Blog | Home
all groups > sql server mseq > may 2004 >

sql server mseq : convert rows into columns


Nikhil
5/12/2004 9:11:02 PM
i have a table which gives me a list of months as records..
ie..columnname : mont
row1: ja
row2: fe
row 3: ma

and so on.
i want to make a column..where these months appear as column nam

ie...column1: ja
column2: fe
column3: ma

also...what i want is if in the first table...any month is added as a row.... the second table should also take the new month as a new column...

let me know asa

regard

Nikhi
Anith Sen
5/14/2004 4:15:52 PM
MSKB (support.microsoft.com) article : 175574

--
Anith

AddThis Social Bookmark Button