SELECT INTO Question?

[Lars Netzel]

This code works:
SELECT * INTO #Temp From tbl_employee
SELECT * FROM #Temp
Drop TABLE #temp

This does not:
SELECT * INTO #Temp From (Select * FROM tbl_employee WHERE EMP_ID = @id
UNION Select * FROM tbl_employee2 EMP_ID = @id)
SELECT * FROM #Temp
Drop TABLE #temp

I need to get everything from a UNION select statement and I also need to
pass parameters to it so I can't use a view for this.

Is there any other way to make this work?

best regards/
Lars Netzel

[Karl Seguin]

Wrong newsgroup, but try adding an AS X to the end of the SELECT * INTO:

SELECT * INTO #Temp From (
Select * FROM tbl_employee WHERE EMP_ID = @id
UNION
Select * FROM tbl_employee2 EMP_ID = @id
) AS ANYTHING

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Lars Netzel" <no****@doamin. com> wrote in message
news:u8******** ******@TK2MSFTN GP12.phx.gbl...

This code works:
SELECT * INTO #Temp From tbl_employee
SELECT * FROM #Temp
Drop TABLE #temp

This does not:
SELECT * INTO #Temp From (Select * FROM tbl_employee WHERE EMP_ID = @id
UNION Select * FROM tbl_employee2 EMP_ID = @id)
SELECT * FROM #Temp
Drop TABLE #temp

I need to get everything from a UNION select statement and I also need to
pass parameters to it so I can't use a view for this.

Is there any other way to make this work?

best regards/
Lars Netzel

[Lars Netzel]

Thank you!

/Lars

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:Op******** ******@TK2MSFTN GP09.phx.gbl...

Wrong newsgroup, but try adding an AS X to the end of the SELECT * INTO:

SELECT * INTO #Temp From (
Select * FROM tbl_employee WHERE EMP_ID = @id
UNION
Select * FROM tbl_employee2 EMP_ID = @id
) AS ANYTHING

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Lars Netzel" <no****@doamin. com> wrote in message
news:u8******** ******@TK2MSFTN GP12.phx.gbl...

This code works:
SELECT * INTO #Temp From tbl_employee
SELECT * FROM #Temp
Drop TABLE #temp

This does not:
SELECT * INTO #Temp From (Select * FROM tbl_employee WHERE EMP_ID = @id
UNION Select * FROM tbl_employee2 EMP_ID = @id)
SELECT * FROM #Temp
Drop TABLE #temp

I need to get everything from a UNION select statement and I also need to
pass parameters to it so I can't use a view for this.

Is there any other way to make this work?

best regards/
Lars Netzel