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.

All Forums  General SQL Server Forums  New to SQL Server Programming  pivot using ansi 92,

Author  Topic  ash benn Starting Member 1 Post Posted - 2009-11-03 : 10:17:53 using a function or Stored Procedure, I want to loop through a column of data and create a another table that uses the row value as Column labels from the row data. Example: table1 a,b,c chi, 12,xx nyc,15,xx atl,16,xx sf,17,xx, table2 xx, chi, nyc, atl, sf then insert data xx,chic, nyc, atl, sf t,12,15,16,17 then insert another set