By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,905 Members | 1,701 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,905 IT Pros & Developers. It's quick & easy.

Creating "Cross Tab tables in SQL?

P: 6
I know that Transform and Pivot are not recognized commands in SQL and I have looked everywhere on how to covert the below query 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
Mar 8 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.