Date: 01/06/05 (SQL Server)    Keywords: sql

i've converted over 150 access queries today that didn't autoconvert during upsizing to sql because of sql language difference. These are the only 2 left i am stuck on. they are cross tab queries with a pivot.

Can you help?

[1] query1:

TRANSFORM Min(statusall_sub1.makesymb) AS MinOfmakesymb
SELECT statusall_sub1.site, statusall_sub1.opsoffice
FROM statusall_sub1
GROUP BY statusall_sub1.site, statusall_sub1.opsoffice
ORDER BY statusall_sub1.site, statusall_sub1.opsoffice, statusall_sub1.sectionid
PIVOT statusall_sub1.sectionid

[2] query2:

TRANSFORM First(sites.transferto) AS FirstOftransferto
SELECT sites.closuretype
FROM sites
WHERE (((sites.closuretype) Is Not Null))
GROUP BY sites.closuretype
PIVOT sites.site;

Source: http://www.livejournal.com/community/sqlserver/14733.html