Good point, I updated my post so the processing is done on a separate transaction in both cases. That way I think the complexity of the work to be done...

You can update a CTE directly, so there's no need for the #BadRecords temp table and the MULTIPLES and BAD sub-queries:

WITH CTE AS(

SELECT ContactId, FieldTypeId, FieldVersion, StartDate,

ROW_NUMBER() OVER (PARTITION...

Cody K (4/1/2014)

I feel like there's quite a large disconnect between the intentions of the author, how the article was read, the comments, and then the author's reply to the...

I have a conspiracy theory about the so-called "IT skills shortage" : it's just a ploy to get more people into IT in order to increase the pool of job...

My thoughts, exactly. You can pick any line in the article and...

If holidays don't exist for you, chances are you work on weekends too, so you might as well use DATEDIFF. But if you are a contractor, you most likely bill by the...

Please tell me: What part of my reply is "hard on the people who ask this question"? Where did I write anything about a "stupid question"? Where did I say one should...

An index is meaningless without an underlying table. Therefore it makes no sense to ask if an indexed view will store the index only. What would be the point of...

Haven't checked for that, I will next time it happens. But to be honest I doubt that's what causes the problem. Why? Because if it was, the problem would go...

This is just one more proof of how the U.S. is slowly but surely becoming a fascist state. If you disagree, just wait. Today, your most private possessions can be...

I'm a bit divided on this one. On one hand, I think you should have quit your job the first day you were yelled at, I can't stand experienced (and...

What were they thinking???? Leaving SQL out of the list of top 10 languages to know is like leaving Bill Gates out of a list of the top 10 wealthiest...