The pattern we use for a similar process is this.

MERGE INTO final_table
USING (SELECT key_column_1
            , key_column_2
...

• This reply was modified 4 years, 4 months ago by Chris Wooding.

I've used BEGIN DISTRIBUTED TRANSACTION. I've got a control table in one database that is kept in line with a copy in another database via a linked server.

Having looked through the "people that have been fired" article, I can say I agree with the outcome in almost every case.

I agree with your point about not being too concerned with titles. In my career I've been a programmer, senior programmer, analyst programmer, senior analyst programmer, data engineer and senior...

Are you able to amend the file layout at all? It may be better to push the problem back to COBOL by adding record no. as a field and getting...

I would say; take the time to learn what your employer does. Many of us in IT work in the IT department of companies whose business is something else entirely....

If I've understood correctly, you write the results of a query to a work table and those results are tagged with a GUID. Other screens then work on this data;...

It seems that standards tend not to be developed until there's already a large body of existing code. You then have a choice of following the standard or following the...

I suspect the speaker was using the word snowflake in its meaning of unique rather than the more recent meaning of easily offended. I've not worked in an IT department...

Turns out our database backups should be reasonably safe - we're still backing up to tape!

If you do each iteration in a branch and only merge those Jira items you want to promote into Main prior to deployment, you can generate a script by comparing...

I think you need something like this (below). As mentioned by Ratbak, you'll need to drop indexes and foreign keys before making the change and you should definitely run it...

• This reply was modified 5 years ago by Chris Wooding.

When adding the reference to the non-managed database, you should set "Suppress Reference Warnings" to True. I think that will get around your problem.

Are you able to see whether it's blocked by another transaction? The fact that it returns null on the occasions when it takes a long time suggests some other process...

Jeff's comment about the cut-off for 2 digit years reminded me that the millennium bug was "fixed" at one place I worked by using YY>20 as the cutoff to guess...