how to copy data from one table to another using store proc?

Karan Thakkar

7y1.1k

I have three table, In staging table there is raw data I want to transfer the data from staging table to active table. Active table has same column like staging just one extra that is staging ID.

In third table I have done mapping like there are 3 columns

1st column has what i want to store in active table

In 2nd column what raw values is in staging table.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sourav Mukherjee7y ago
1. Create proc Schema.Proc (@C1 int)
2. AS
3. BEGIN
4. INSERT INTO Table2 (C1, C2, C3)
5. SELECT C1, C2, C3 FROM Table1 WHERE C1 = @C1
6. END

Sanwar Ranwa7y ago

Hello Karan

check these

CREATE TABLE [dbo].[tbl1](
[C1] [int] NULL,
[c2] [int] NULL,
[c3] [int] NULL
)
CREATE TABLE [dbo].[TBL2](
[C1] [int] NULL,
[C2] [int] NULL,
[C3] [int] NULL,
[C4] [int] NULL,
[C5] [int] NULL
)
CREATE PROCEDURE USP_tbl
(@C1 int)
AS
BEGIN
INSERT INTO Tbl1(C1, C2, C3)
SELECT C1, C2, C3 FROM tbl2
WHERE C1 = @C1
END
exec USP_tbl 2

You can modify according your cnsitions

Kalyani Shevale7y ago

try this Query

INSERT INTO newTable
SELECT * FROM oldTable
INSERT INTO newTable (col1, col2, col3)
SELECT column1, column2, column3
FROM oldTable

CREATE TABLE new_table SELECT * FROM original_table;

otherwise, u have used join for two tables then copy this table in another table