Hi!

I don't understand the second question,

but for the first one I think this could be helpfull:

instead of:

@cSQLCmd = 'SELECT ' + cSQLLine + ' FROM INSERTED'
INSERT INTO #TempTbl EXEC (@cSQLCmd)

you can do this:

@cSQLCmd = 'SELECT ' + cSQLLine + ' INTO ' + @cTempTbl + ' FROM INSERTED'

having in @cTempTbl the name of your temporary table.