Create a table from two other tables. 1

[Crewdawg]

I need to create a table based on the structure and data in two other tables. These source tables both contain the same structure. I have tried the query as follow, which results in a syntax error:

DROP TABLE COMB_LABOR
CREATE TABLE COMB_LABOR
AS (SELECT 8 FROM "GDB_01_8"."DBO"."WOMNT_LABOR", "GDB_01_8"."DBO"."WO_LABOR");

Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.

I have had little luck getting joins to assist me. I have used the DTS Import / Export wizard as well. Until I can figure out what I am doing incorrectly with joins this seems like a temporary solution (while less efficient).



----------------------------------------
Multithreading is just one thing after, before, or simultaneous with another.

 

[SQLDenis]

This should work (in theory)

DROP TABLE COMB_LABOR
select * into COMB_LABOR
from (SELECT * FROM "GDB_01_8"."DBO"."WOMNT_LABOR" union all
SELECT * FROM "GDB_01_8"."DBO"."WO_LABOR") xx ;

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Crewdawg]

Now how to I make this a stored procedure and execute it?

Sean H

----------------------------------------
Multithreading is just one thing after, before, or simultaneous with another.

 

[jbenson001]

See Create Procedure in Books On Line.

 

[Crewdawg]

Thanks a bunch. Worked great.

----------------------------------------
Multithreading is just one thing after, before, or simultaneous with another.

 

[jbenson001]

No problem.. Books On Line is your friend