yeah, that matches what i see, and i agree w/ the reason why. in my paramterized example above, i gave them default values (null), which i why i think LabKey allows that query. I assume it evaluates the PIVOT column list using those default parameter values.

and yes, i ended up doing the less elegant solution of building SQL client-side and using executeSql to get my data.

thanks.