--Create Source Table 
CREATE TABLE INPUT_DATA (
  COL1  INT  NOT NULL)
GO

INSERT INTO INPUT_DATA VALUES (21);
INSERT INTO INPUT_DATA VALUES (22);
INSERT INTO INPUT_DATA VALUES (23);
GO


--Create Target Tables
CREATE TABLE OUTPUT_DATA1 (
  PK_COL1 INT PRIMARY KEY)
GO

CREATE TABLE OUTPUT_DATA2 (
  PK_COL1 INT PRIMARY KEY)
GO

--Put one row in the second target table
INSERT INTO OUTPUT_DATA2 VALUES (23);
GO


--Check contents of target tables
SELECT * FROM OUTPUT_DATA1

SELECT * FROM OUTPUT_DATA2


--Empty First target table before a re-run
TRUNCATE TABLE OUTPUT_DATA1