SQL Statement Help... Ignore already existing rows
Posted
by
Funchy
on Server Fault
See other posts from Server Fault
or by Funchy
Published on 2012-04-11T22:23:07Z
Indexed on
2012/04/11
23:33 UTC
Read the original article
Hit count: 127
sql
I have a table with a foreign key constraint and the command below gives me an error because it's trying to set a value that already in the provider table. How do I update this command to ignore those rows that already exist in the provider table?
UPDATE b SET b.iProvider_PVN = a.POIN FROM dbo.ASPVNTOPOIN_stg a INNER JOIN dbo.Provider b ON a.ASPVN = b.iProvider_PVN AND b.vcProv_Type = 'IPA' LEFT JOIN dbo.Provider c ON a.POIN = c.iProvider_PVN WHERE c.iProvider_PVN IS NULL
© Server Fault or respective owner