Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Updating a table using a stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-30 : 08:33:52
Stephen writes "I want to run a report weekly - taking new data from one temporary table and adding the records to a second permanent table. I will be checking to see if the record currently exists by comparing the primary key...
My problem is this: when I execute the stored procedure it adds all the records each time it finds a record that doesn't match...

I can't get it to add only the new records...

Can you please shed some light on this?

Thanks... S."
   

- Advertisement -