<div>
Should it be a new table or just a query to make a pivot table ?<br />
Please post sample data, current shape + expected results.<br />
<br />
With the information you have given so far, the best I can come with is<br />
- issue a select * in QA<br />
- copy output to an excel file<br />
- use Excel rotate functionality<br />
- change column names at will<br />
- import xl file into a new table using DTS
</div>


Should it be a new table or just a query to make a pivot table ?
Please post sample data, current shape + expected results.

With the information you have given so far, the best I can come with is
- issue a select * in QA
- copy output to an excel file
- use Excel rotate functionality
- change column names at will
- import xl file into a new table using DTS

<div>
<div class="content wysiwyg-content">
I need command or script to convert rows into columns or vice-versa in MS SQL 2000. Any one has ideas or commands?
</div>
</div>


I need command or script to convert rows into columns or vice-versa in MS SQL 2000. Any one has ideas or commands?

Script to convert rows into column or vice-versa

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.