RMu
Reputation: 869
TSQL - If Exists Update Else Insert
I have a data file with data in below format.
--removed the data and query
Thank you!
Upvotes: 0
Views: 190
Answers (1)
Richard Kemp
Reputation: 323
Reverse the order of operations - first update lookup tables, then do your import merge. You can remove your temp table, the inserts, and updates for those lookup tables. You just need a merge statement to bring in the new and/or updated rows.
Upvotes: 2
Related Questions
- Check if a row exists, otherwise insert
- SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE
- MS SQL Server 2012 - Insert Values if row does not exist
- SQL: IF NOT EXISTS INSERT then UPDATE
- SQL Query to update or insert row with If Exists statement not working
- SQL Server if exist update else insert
- SQL : update if present insert if not
- TSQL insert if not exists
- SQL Server: Insert if doesn't exist, else update and insert in another table
- If exist update else insert records in SQL Server 2008 table