Creating Cross-Tab query in SQL?
I know that Transform and Pivot are not recognized commands in SQL and I have looked everywhere on how to covert the below query from Access to run properly in SQL, but I can't seem to find the answer.
If someone could help, that would be awesome.
TRANSFORM Count(ConfirmOriginRecords.PHNum) AS [The Value]
SELECT ConfirmOriginRecords.SendZip, Count(ConfirmOriginRecords.PHNum) AS [Total Of PHNum]
GROUP BY ConfirmOriginRecords.SendZip