Hi,

Did we get a resolution on this? I am getting a similar issue on Windows 2008R2 and SQL Server 2008 sp1.

Thanks

SELECT INTO will always fail if the table already exists so you have two options:

• predefine the temporary table then INSERT INTO .... SELECT in both If instances
• SELECT ...  INTO in...