SQLquery:To check the condition & then insert the data if not existing

Meghana M

SQL query for the below scenario

eg: Employee table has 10 rows

The TempEmployee table has 5 rows

TempEmp table should compare with the employee table and insert rows that are not present in the TempEmp

select emp.no, emp.name from dbo.Employee emp
left join dbo.TempEmp temp on temp.no =emp.no
where emp.no is not null and ltrim(rtrim(emp.no))

2 Replies

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

Jignesh Kumar2y ago

Hello Meghna,

You can try this one,

INSERT INTO dbo.TempEmp (no, name, address, gender)
SELECT emp.no, emp.name, emp.address, emp.gender
FROM dbo.Employee emp
LEFT JOIN dbo.TempEmp temp ON temp.no = emp.no
WHERE emp.no IS NOT NULL AND temp.no IS NULL;

Jayraj Chhaya2y ago
To achieve this, you can use the INSERT INTO statement along with the SELECT statement and the LEFT JOIN clause. Here's an example SQL query that accomplishes the task:
```
INSERT INTO dbo.TempEmp (no, name)
SELECT emp.no, emp.name
FROM dbo.Employee emp
LEFT JOIN dbo.TempEmp temp ON temp.no = emp.no
WHERE emp.no IS NOT NULL AND LTRIM(RTRIM(emp.no)) IS NULL;
```
You can compare the Employee table with the TempEmp table and insert the rows that are not present in the TempEmp table.