Posted by Plamen Ratchev on 06/05/07 12:28

You can use CASE, like this:

SELECT Cust,
CASE WHEN Type = 1
THEN Amount ELSE 0.0 END AS Type1,
CASE WHEN Type = 2
THEN Amount ELSE 0.0 END AS Type2
FROM Foobar

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Copy Row Of Data From Table to Table In Same DB
• Prev in forum: Re: How to?
• Thread view: Re: How to?

[Reply to this message]