>Hi all
>
>I want to crate a temp table based on a value passed to a stored procedure. Basically I'm trying to do this:
>

>If (some critera)
>  select (field list) into #SubFile from CATMaster where (otherstuff)
>else
>  Select (field list) into #SubFile from CatMaster where (otherstuff, slightly different from the first)
>

>
>It's giving me the red squiglly line under the 2nd #Subfile and telling me that one already exists in DB.
>
>What is the correct way to do what I want to do in SQL?

it is a SQL SERVER bug.

try this code with and without GO commented.

SELECT x = 1 INTO #T1
DROP TABLE #T1
--GO
SELECT x = 2 INTO #T1