I've got an Access query that I've been using for a while and now I need to convert it to query an SQL Server DB. The problem is that I'm not very familiar with querying SQL servers so I'm at a loss as to how to convert. The query is:
Code:
TRANSFORM Count([Incident #]) [Count]
SELECT [Assoc ID]
FROM _smdba_.Incident
WHERE [Open Date & Time] >'2010-12-31'
GROUP BY [Assoc ID]
PIVOT FORMAT([Open Date & Time], "ww", 2,2);
Basically I want to query our incident database and return the number of incidents entered per associate on a weekly basis.
I'd appreciate any help!