SQL Help with Pivot

[cs2009]

Using SQL Server 2005.

I have data in a table like this:

Product Cost 1 Cost 2 Bkt

MUOV18I001108 2.47 0.00 1
MUOV18I001108 0.08 0.00 2
MUOV18I001108 0.13 0.00 3
UOIBQVV237BGD 1.39 0.34 1
UOIBQVV237BGD 0.97 1.76 2
UOIBQVV237BGD 1.18 0.25 3

And I want to display it like this:

MUOV18I001108 2.47 0.00 0.08 0.00 0.13 0.00
UOIBQVV237BGD 1.39 0.34 0.97 1.76 1.18 0.25

Can someone help with the query? Maybe a pivot command?

Thanks.

 

[markros]

You need here a dynamic pivot. Here is a recent helpful thead on MSDN forum with it

http://social.msdn.microsoft.com/Fo.../thread/0677db57-9e28-4b62-ab8f-d2af67c25123/

(see last answer in that thread).

PluralSight Learning Library