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!!!
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!!!