|
Subject:
|
Creating Cross-Tab query in SQL?
|
|
Posted By:
|
WebLadyBug
|
Post Date:
|
3/9/2007 8:57:41 AM
|
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.
Thanks!
TRANSFORM Count(ConfirmOriginRecords.PHNum) AS [The Value]
SELECT ConfirmOriginRecords.SendZip, Count(ConfirmOriginRecords.PHNum) AS [Total Of PHNum]
FROM ConfirmOriginRecords
GROUP BY ConfirmOriginRecords.SendZip
PIVOT ConfirmOriginRecords.SendDay
|
|
