如何把union 得到的结果放到临时表中去
(
select *from table1
union all
select *from table2
)
　　into #temp3....................这样的语句应该怎么写

也就是说如何把union 得到的结果放到临时表中去

[解决办法]

SQL code

select * into # from (     select *from table1     union all     select *from table2     ) t
[解决办法]
SQL code
CREATE TABLE #A (ID INT,   AMT    INT,        S_DATE VARCHAR(10))INSERT #ASELECT 1,  3000,  '2008-11-21' UNION ALL SELECT 1,  5000,  '2008-11-19' UNION ALL SELECT 2,  4000,  '2008-11-17' UNION ALL SELECT 2,  6000,  '2008-11-19' UNION ALL SELECT 3,  1000,  '2008-10-12' UNION ALL SELECT 3,  200,  '2008-11-02'CREATE TABLE #B (ID INT,   AMT    INT,        S_DATE VARCHAR(10))INSERT #BSELECT 1,  3000,  '2008-11-21' UNION ALL SELECT 1,  5000,  '2008-11-19' UNION ALL SELECT 2,  4000,  '2008-11-17' UNION ALL SELECT 2,  6000,  '2008-11-19' UNION ALL SELECT 3,  1000,  '2008-10-12' UNION ALL SELECT 3,  200,  '2008-11-02'SELECT * INTO #C  FROM (SELECT * FROM #AUNION ALLSELECT * FROM #B)ASELECT * FROM #CDROP TABLE #A,#B/**ID          AMT         S_DATE     ----------- ----------- ---------- 1           3000        2008-11-211           5000        2008-11-192           4000        2008-11-172           6000        2008-11-193           1000        2008-10-123           200         2008-11-021           3000        2008-11-211           5000        2008-11-192           4000        2008-11-172           6000        2008-11-193           1000        2008-10-123           200         2008-11-02