Thank you for your reply Keren.

I believe I see the error of my ways....I was attempting to use a portion of your code within a trigger.

To be precise the section:

declare @VarRandom NVARCHAR(50)

set @VarRandom=ltrim(str(replace(Rand(), '.', '')))

SELECT * INTO #deleted'+@VarRandom+' FROM deleted

SELECT * INTO #inserted'+@VarRandom+' FROM inserted

this is where I get the syntax error. Is the above possible within a trigger?