Posted by markc600 on 04/12/06 22:04

SELECT Date,
SUM(CASE WHEN ProductTypeID=1 THEN Quantity ELSE 0 END) AS Type1,
SUM(CASE WHEN ProductTypeID=2 THEN Quantity ELSE 0 END) AS Type2,
SUM(CASE WHEN ProductTypeID=3 THEN Quantity ELSE 0 END) AS Type3
FROM TableA
GROUP BY Date

• Next in forum: Re: insert into temp table based on if condition
• Prev in forum: Re: insert into temp table based on if condition
• Thread view: Re: SQL Query Question

[Reply to this message]