Ron Cicotte (2/27/2015)

---

Another (more efficient) way to solve this problem without using a LEFT OUTER JOIN or even WHERE NOT EXISTS (which btw is even less efficient) is to use...

Perhaps a more detailed explanation will make things more clear.

I'm selecting records from a table (PARENT) and inserting them into the same table but with a new PK (and one...

venoym - The OUTPUT clause was first introduced in MS SQL Server 2005.

venoym and Sean - Please re-read the only bold font sentence in my last post and the sentence...

Thanks Kevin and Sean for the informative links. After reading them I'm actually less concerned about using MERGE for copy forward operations.

I apologize for not posting sample code for...

Thanks for the reply Kevin.

"Buggy" and "issues" are vague terms, but I get the picture. Also, I'm OK just taking your word for it on the triggers! My goal...

@SSC Thanks for reposting this article. I missed it when it came out over a year ago!

@ Jeff Moden - I know this was long ago, but back then...

Jeff Moden (1/23/2014)

---

If the quotes are consistent in the column, then you are, in fact, missing out on a format file option that MS didn't document because they "don't...

Great article! Exellent choice on where to draw the line on its scope.

Also, sometimes it's just as valuable to learn what can't be done as it is to learn...

Tavis Reddick (1/9/2014)

One import error I think we may have experienced occasionally with a data import is the insertion of a row with a primary key which duplicates one already...

rstone (12/9/2013)

---

I think RBAR is an option to avoid locking too many resources at once to avoid a costly re-design. (A business decision to not re-design can be valid.)

On...

GeorgeCopeland (12/8/2013)

---

But here is the deal: it processes until it abends. It fails on the offending record and writes out a meaningful error message. After the problem is fixed, the...

thisisfutile (11/12/2013)

I remember learning that lesson too. Before I knew I could add it to the ON clause, I always solved this type of query with

WHERECourseCompleted.CourseId IS NULL

AND ISNULL(CourseCompleted.DateComplete,'12/31/2012')...

Hey deroby, don't feel bad. I'm betting many readers would've made the same comment if you hadn't beat them to it! You're...

brymen (11/12/2013)

---

...If the article ended with deroby's post, It would be a 5 star article. It has been my experience that WHERE NOT EXISTS always meets or beats a...

Thanks for this nice piece of code! I encountered a need for this not that long ago.

I tried it on our older development SQL 2005 server (9.00.4060.00) and ran...