To handle nulls, I changed the code to the following:

OLD CODE

set @ValList = @ValList + ' ''+convert(varchar(200),' + @ColName + ')+'''

NEW CODE

set @ValList = @ValList + ' ''''''+isnull(convert(varchar(200),[' + @ColName...