I've got a Crosstab Query in Access that I'm trying to convert to SQL 2005 and after beating my head for 3 days, I'm wondering if someone can help me out a bit.
Any help would be appreciated.
How many distinct values exist for tblPivotTest.PERIOD? If there are only few static values which can be hardcoded in the code, then PIVOT examples here should help. But if there are many values then dynamic sql can be used
answered Jul 25, 2012 at 09:34 AM