Hi,
I have the following query and would like to be able to control the pivot statement through two parameters. Tentatively, I have put 1 and 21 for testing purposes and would like to replace it with variables once I got it working.
TRANSFORM Nz(Count(Case_ID),0) AS CountOfCase_ID
SELECT...