Advertisement
Guest User

Untitled

a guest
Nov 6th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. exec ('
  2. UPDATE DI
  3. SET DI.Field1 = src.Field1
  4. ,DI.Field2 = src.Field2
  5. ,etc
  6. FROM tablename DI
  7. INNER JOIN Server.Dbase_ ' + @client + '.dbo.tablename src
  8. ON DI.key = src.key
  9. WHERE DI.dbcode = ''' + @client + '''
  10. and src.lastedit_date > DI.lastedit_date
  11.  
  12. insert into tablename
  13. (dbcode, Field1, Field2, etc)
  14. select
  15. ''' + @client + '''
  16. ,Field1
  17. ,Field2
  18. ,etc
  19. FROM Server.Dbase_ ' + @client + '.dbo.tablename
  20. WHERE key NOT IN (SELECT key FROM tablename where dbcode = ''' + @client + ''')
  21. ')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement