question

Hung avatar image
Hung asked

SQL pulling data

Hi,

Is there a way in SQL that can display the data from table#1 like table#2?

Thanks A lot!!!

table#1 product seller# seller_ID apple 12456 QB1 apple 12456 QB2 apple 12456 QB3

table#2 product seller# seller_ID seller_ID seller_ID apple 12456 QB1 QB2 QB3

sql-server-2008sql-server-2005ssisbackupselect
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Squirrel 1 avatar image
Squirrel 1 answered

yes. check out PIVOT operator

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.