Query to Insert record into another table using Select Statement in SQL Server

LoganTRK

SOLVED CLOSED ACTIVE ANSWERED
User: LoganTRK
Posted: on Nov 22, 2018 07:23 PM
Forum: SQL Server
Answer: 1
Views: 2573

Hello ,

what i need is to select informattion from certain tables and insert them into another table . insert two tables into total_g1 with id , total , and name of the table . Regards

SELECT ID, Sum(total) FROM Table1 WHERE Year = 2010 GROUP BY ID

SELECT ID, Sum(total) FROM Table2 WHERE Year = 2010 GROUP BY ID

INSERT INTO TOTAL_G1 (ID, TOTAL, Name_Table) VALUES ('@id','" @total "','Table1')"

INSERT INTO TOTAL_G1 (ID, TOTAL, Name_Table) VALUES ('@id','" @total "','Table2')"

pandeyis...

0 3

Reply
ANSWER
User: pandeyism
Replied: on Nov 22, 2018 11:31 PM
Report

Hey LoganTRK,

Please refer below query.

SQL

INSERT INTO TOTAL_G1 (ID, TOTAL, Name_Table)
SELECT ID, Sum(total),'Table1' 
FROM Table1 
WHERE Year = 2010 
GROUP BY ID

INSERT INTO TOTAL_G1 (ID, TOTAL, Name_Table)
SELECT ID, Sum(total),'Table2' 
FROM Table2 
WHERE Year = 2010 
GROUP BY ID

Query to Insert record into another table using Select Statement in SQL Server

Company

Explore

Follow us

Contact Us