Re: pivot table without aggregation?

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.
.