Ok, I am getting the "Scaling of decimal value resulted in data truncation" which I know what it means but cannot figure out how to fix it. We upgraded are database from a 2000 version and the new version does not like the following query. I have isolated the problem to the crosstab row...