asked on

PIVOT works fine for MsAccess - Now I am converting to MSSql - How please?

this PIVOT works fine for MsAccess - Now I am converting to MSSql - How would I do this please?

TRANSFORM Sum(AceData.InCredit) AS SumOfInCredit
SELECT AceData.Type
FROM ListJob INNER JOIN AceData ON ListJob.JobList = AceData.Job
WHERE (((ListJob.ScenarioAccountant)=True))
GROUP BY AceData.Type
PIVOT AceData.Job;

ASKER CERTIFIED SOLUTION

borki

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

goodk

ASKER

sql 2008

Microsoft SQL Server Management Studio                                    10.0.2531.0
Microsoft Data Access Components (MDAC)                                    6.0.6002.18005
Microsoft MSXML                                    3.0 4.0 5.0 6.0
Microsoft Internet Explorer                                    8.0.6001.19019
Microsoft .NET Framework                                    2.0.50727.4206
Operating System                                    6.0.6002

SOLUTION

Jeffrey Coachman