MSSQL syntax

[addrianne]

this is a sql syntax from microsoft access...

TRANSFORM Avg(dbo_tbl_000_ClassPrice_CSL.PriceAmount) AS AvgOfPriceAmount
SELECT dbo_tbl_000_ClassPrice_CSL.ClassName
FROM dbo_tbl_000_ClassPrice_CSL
GROUP BY dbo_tbl_000_ClassPrice_CSL.ClassName
PIVOT Format([EffectiveDate],"Short Date");


can anyone translate this to MSSQL syntax?
please..please..please...

 

[markros]

Well, you should be looking into PIVOT command (SQL Server 2005 and up), but it's a bit hard to suggest something without your table structure, some sample data and desired output.

 

[SCCOIR]

Addreianne, did you ever get a response to this? I have exactly the same need and would love to see a reply.