Posted by Gert v O on 01/18/06 20:49

Can someone help me parsing this ms-access PIVOT sql-statement to a
ms-sql-server sql-statement?
Many thanks in advance

TRANSFORM Count(KlantenStops.id) AS AantalVanid
SELECT KlantenStops.Uitvoerder, KlantenStops.Klant
FROM KlantenStops
GROUP BY KlantenStops.Uitvoerder, KlantenStops.Klant
PIVOT DatePart("m",leverdatum,1,0) In
("1","2","3","4","5","6","7","8","9","10","11","12");

• Next in forum: Re: Can I use stored procedures with PHP via ODBC bridge?
• Prev in forum: Can I use stored procedures with PHP via ODBC bridge?
• Thread view: Help wanted msaccess PIVOT-query --> MS-SQL view/sp

[Reply to this message]