Whats wrong here?

[theJonster]

SELECT *
into #temp
FROM
(SELECT *
FROM vwActor

UNION

SELECT *
FROM vwDirect)

tryin to put contents of both views into one temp table...both hav same fields.

Thnks

[almaz]

Please don't create several topics for the same problem


Try this:

SELECT *
into #temp
FROM 
(SELECT * 
FROM vwActor

UNION

SELECT *
FROM vwDirect) Source