Posted by Ed Murphy on 03/30/07 01:11

Plamen Ratchev wrote:

> SELECT SUM(CASE WHEN [Name] = 'Product A' THEN RankID ELSE 0 END) AS
> 'Product A',
> SUM(CASE WHEN [Name] = 'Product B' THEN RankID ELSE 0 END) AS
> 'Product B',
> SUM(CASE WHEN [Name] = 'Product C' THEN RankID ELSE 0 END) AS
> 'Product C'
> FROM PRODUCTS

I think SQL Server 2005 has a built-in pivoting function, but I've
never used it so I don't know the syntax.

[Back to original message]