Convert msaccess pivot to mssql pivot
-
Hi i want to convert msaccess pivot query to mssql server 2005 pivot query can anybody help me?
TRANSFORM Sum([Kartella1-meion].[m]) AS ΆθροισμαΤουm
SELECT [Kartella1-meion].[PEL_PRO_CODE], Sum([Kartella1-meion].[m]) AS meion
FROM [Kartella1-meion]
GROUP BY [Kartella1-meion].[PEL_PRO_CODE]
PIVOT Format([HME_PAR],"mmm") In ("Ιαν","Φεβ","Μαρ","Απρ","Μαϊ","Ιουν","Ιουλ","Αυγ","Σεπ","Οκτ","Νοε","Δεκ"); -
Hi i want to convert msaccess pivot query to mssql server 2005 pivot query can anybody help me?
TRANSFORM Sum([Kartella1-meion].[m]) AS ΆθροισμαΤουm
SELECT [Kartella1-meion].[PEL_PRO_CODE], Sum([Kartella1-meion].[m]) AS meion
FROM [Kartella1-meion]
GROUP BY [Kartella1-meion].[PEL_PRO_CODE]
PIVOT Format([HME_PAR],"mmm") In ("Ιαν","Φεβ","Μαρ","Απρ","Μαϊ","Ιουν","Ιουλ","Αυγ","Σεπ","Οκτ","Νοε","Δεκ"); -
Here is a CodeProject article to get you started Simple Way To Use Pivot In SQL Query[^]
