LiCann
asked on
Pivot Table
Can I use the SQL from Access below exactly the same in a stored Proc? I do not have access to test in SQL Server right now.
TRANSFORM Count(AllStat.Position) AS CountOfPosition
SELECT AllStat.[Position Status]
FROM AllStat
GROUP BY AllStat.[Position Status]
PIVOT AllStat.Age;
TRANSFORM Count(AllStat.Position) AS CountOfPosition
SELECT AllStat.[Position Status]
FROM AllStat
GROUP BY AllStat.[Position Status]
PIVOT AllStat.Age;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No, that syntax is not valid in TSQL