How can APPEND data into a table only if record does not exist. 1

[jms493]

I want to run a a query at any time and only inserts/appends data to the table if the record does not exist. No duplicate rows.

How can write this?

 

[AlexCuse]

If you have a (real) primary key, you can use a left join.

insert into myTable
select a.* from myOtherTable a
left join myTable b
on a.PK_Value = b.PK_Value
where b.PK_Value is null

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SQLDenis]

if not exists (select * from table where key ='somevalues here')
insert table
select <values>





Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[jms493]

Beautiful Dennis.....Stored procedure created and job created to run every month.

Thanks for the help guys. People will think I am actually smart today!