Advertisement
anchormodeling

Example Stage (day 1): Merge Script

Sep 6th, 2013
2,560
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.60 KB | None | 0 0
  1. MERGE INTO lST_Stage AS st
  2. USING Stages_Raw_day1 AS src
  3. ON
  4.     -- this should be the natural key
  5.     src.[address] = st.ST_LOC_Stage_Location
  6. -- if the key was known then logically update (actually insert) possibly changed valued
  7. WHEN MATCHED THEN UPDATE
  8. SET
  9.     st.Metadata_ST = 42,
  10.     st.ST_NAM_Stage_Name = isnull(src.[name], st.ST_NAM_Stage_Name)
  11. -- if the key was unknown then insert the new values (an identity will be automatically created)
  12. WHEN NOT MATCHED THEN INSERT (
  13.     Metadata_ST,
  14.     ST_NAM_Stage_Name,
  15.     ST_LOC_Stage_Location
  16. )
  17. VALUES (
  18.     42,
  19.     src.[name], -- works even if null
  20.     src.[address]
  21. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement