Hello:
I have this table [temp1] which is populated with some records.
Now I want to construct another table [temp2] , such that the 7 row of table [temp1] becomes column field for table [temp2] i.e... 7th row of table [temp1] is the header information for table [temp2].
and from row 8 of table [temp1], I need to load all those row, which will become data row for table [temp2].
Is there any easy way to do this...I am using MS SQL server 2005, and we don't want to use any third party tools for it.
Thanks,
saby
I have this table [temp1] which is populated with some records.
Now I want to construct another table [temp2] , such that the 7 row of table [temp1] becomes column field for table [temp2] i.e... 7th row of table [temp1] is the header information for table [temp2].
and from row 8 of table [temp1], I need to load all those row, which will become data row for table [temp2].
Is there any easy way to do this...I am using MS SQL server 2005, and we don't want to use any third party tools for it.
Thanks,
saby