Transpose Rows to Columns? 2

[lemkepf]

Hello SQL Gods again... this is the second post today... let's just say the brain is going with all this nice weather!

Here is the problem... I want to compare 2 products right next to each other on an ASP page. what i would like to do is to convert the rows of each sku into columns. SOOO... instead of this:

ID Sku Name Date
2 414 Stuff 01/04/03
3 453 stuf2 03/04/03

To look like...

ID 2 3
Sku 414 453
Name Stuff stuf2
....
and so on. Soooo anyone know of a quick way to do this via SQL?
Thanks again guys you are a real help!!!

 

[cmmrfrds]

If it is an ASP page then I assume your recordset is an ADO recordset. The getrows method of the recordset will return the rows and columns inverted. The index structure is counterintutitive as the fields will be dimension 1 and the rows dimension 2 in the array returned by getrows.

 

[aneesahmed]

This Can be Achieved by Using the Cross-tab Query.
Please refer to Books Online for more details.

 

[lemkepf]

Cross tab query worked! Thanks!