Nope,  ID's are actually system assigned so they never go over 9 characters.    Beyond that though, in the error email it showed the data the user was trying to submit...

Interesting.  Thank you

Thank you!     I have rewritten it and it is working as intended.

I just needed to think outside of the T-SQL box and use a non-ANSI join.  I have it working  now

ALTER PROCEDURE [dbo].[BobReport]

AS

Thanks chef  but command line wont cut it either.     btw  she not he.

Well crap...  I was afraid of that.    It is not a simple query which is why I showed the 2nd sproc.  This Manager is in charge of a number of...

I believe so.  The CASE statement says if there is no value to enter 0

Thank You!!

Yes.

it is working   needed to aggregate the data.  so my final query is 

SET @PivotQuery = 'SELECT QuestionText, '+ @Cols +' FROM (SELECT QuestionText, AverageAnswer, ResponseText...

I found one thing wrong in how I am enclosing the columns.  so instead of using apostrophes I am using brackets  like so

SET @Cols =...