Thought I would provide a little more insight on a pivot table.

A pivot table query actually uses a physical PIVOT TABLE.

For example, if you wanted to pivot the first three...

SQL Server does not support the MS Access Pivot Table. OUCH!!!

There are a number of methods to reproduce the Pivot Table in SQL Server....

Dale,

Thanks for taking the time to write a good article. I especially appreciate the screen shots.

A couple questions:

1) Where would you recommend a person go for assistance when the...