When you use "IF NOT EXISTS", you should also check and ensure the table exists. E.g., this demo code:

IF NOT EXISTS(

SELECT * FROM sys.columns

WHERE object_ID=object_id('HumanResources.Employee')

AND col_name(object_ID,column_Id)='BusinessEntityID'

)

BEGIN

--it doesn’t exist so do...

I modified your code to make it more useful.

DECLARE @s-2 NVARCHAR(MAX)

DECLARE @result INT ...

You guys are all genius!

Thanks. Your solution both works like a charm.:-D