Create a "pivot table" using SQL - ASAP

[1cutedimple]

I have a table which looks like this:

Account# | Debit_Points | Bonus_points | Offer
123456789| 22 | 5 | MULTI10
234567890| 0 | 50 | MULTI20
987654100| 109 | 100 | MULTI30

I need to create a table that looks like this:

Account# | Debit_Points | MULTI10 | MULTI20 | MULTI30
123456789| 22 | 5 | |
234567890| 0 | | 50 |
987654100| 109 | | | 100

How can I do this using SQL?
Thanks in advance!

 

[AndyInNC]

Try something like:

[tt]
SELECT AccountNum, Debit_Points,
CASE WHEN Multi10 THEN Multi10 ELSE 0 END AS Multi10,
CASE WHEN Multi20 THEN Multi20 ELSE 0 END AS Multi20,
CASE WHEN Multi30 THEN Multi30 ELSE 0 END AS Multi30

FROM ...
[/tt]