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 |
|
petre
Starting Member
11 Posts |
 Posted - 2010-10-03 : 00:20:08
|
| hi friends, i have a table @tmp that has two columns but four rowsit slooks liek this: id csv_values1 hello <---- maps to message column in table1 2 f <---- maps to is_valid column in table13 1 <---- maps to is_active column in table1each row should be represent a column in abnother tablesuchas table1message | is_valid | is_actvetherefore i need to convert those rows in the @tmp to columns as: hello | f | 1How do i convert those rows to columns? PS: once i convert rows to columns then only i can assign that row of data to the table1thanks |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-04 : 09:41:17
|
| will number of columns be static always?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
how do i convert rows to columns?