Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- exec ('
- UPDATE DI
- SET DI.Field1 = src.Field1
- ,DI.Field2 = src.Field2
- ,etc
- FROM tablename DI
- INNER JOIN Server.Dbase_ ' + @client + '.dbo.tablename src
- ON DI.key = src.key
- WHERE DI.dbcode = ''' + @client + '''
- and src.lastedit_date > DI.lastedit_date
- insert into tablename
- (dbcode, Field1, Field2, etc)
- select
- ''' + @client + '''
- ,Field1
- ,Field2
- ,etc
- FROM Server.Dbase_ ' + @client + '.dbo.tablename
- WHERE key NOT IN (SELECT key FROM tablename where dbcode = ''' + @client + ''')
- ')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement