>>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?
>
>If you want to create a temp table of the same structure when
>

>select fieldlist into #SubFile from ... where 1= 0
>
>if ...
>   insert into #SubFile
>   select  .... where
>else
>  insert into #SubFile
>  select ... where ...

I'll give this a try and let you know how it works out.