FROM TableA as a
JOIN TableB as b
  ON a.Service_Part = b.Service_Part
JOIN TableC as c
  ON b.Production_Part = c.Production_Part 

I sure hope TableC...

'''s broken again

^ 

But if you sort by locale DESCENDING as in the possible answers, you will get the correct answer if you supply all the columns for George Bailey's record. ...

How about concatenating the address pieces, and then comparing the two resulting strings?

Remember to handle any pieces of the address that are null.  And you might consider replacing...

Are you using SSIS?
If so, you can set up a variable to hold the last SEQNum found on the SQL side, say we call it LastNum.  Then set up...

You might also want to consider what happens if your nvarchar(100) column contains more than 16 digits.

You said you have 2 columns which combine to make a primary key.

And from the newly staged data, any (or none) of 80 columns could change*.  (The...

Of course the absolute easiest way of doing it is
WHERE YEAR([date]) = 2015
But that's not sargable.  It doesn't matter if you're looking at only a few...

What do you want to fail?  You've already staged the data with a duplicate.  What happens to that staged data?

If all you want is to stop further processing,...