I continued with my previous method until someone could give clarity on the above. Working with the message relating to converting as a string I now have a different error....

Hi,

How does this know what MON* column to put into as that is the value that is changing:

SET @PLUSONE = @REPORTEDMONTHS+1

SET @NAMECOLUMN = 'MON'

SET @col = (SELECT CONVERT(varchar(5), @NAMECOLUMN) +...

Hello All,

thanks for coming back to my post,

i'm using the cursor as i need to cycle through the records one by one

TEMPMONTHLYMATCHES_REPORTEDMONTHS contains the following;

APP_ID = unique serial that...