Brilliant solution to scripting table data. I ran into trouble with one column name "%Target" so, I added square brackets around @ColName and that fixed my issue.

begin

set @ColList = @ColList + ' ' + '['+ @ColName + ']'

if @ColType in (173, 104, 106, 62, 56, 60, 108, 59, 52, 122, 48, 165) -- numeric types (nulls not supported yet)

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

else if @ColType in (175, 239, 231, 231, 167) -- uid and string types

set @ValList = @ValList + ' ''''''+isnull(' + '[' + @ColName + ']' + ',''null'')+'''''''

else if @ColType in (58, 61) -- dates (nulls not supported yet)

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

else if @ColType = 36 -- uniqueidentfiers (nulls not supported yet)

set @ValList = @ValList + ' ''''{''+convert(varchar(200),' + '[' + @ColName + ']' + ')+''}'''''

if @DebugMode = 1 begin print '-- @ValList: ' + rtrim(@ValList) end

if (@ColStatus & 0x80) = 0x80 begin set @IdentityInsert = 1 end -- Check if column has Identity attribute

fetch next from csrColumns into @ColName, @ColType, @ColStatus

end

Thanks,

Johnny