Terrific, thank you for confirming this!

Awesome, thank you!

Yessir, all is well! 🙂 Thank you for checking back in!

Normally I would be sharing all my code. But this particular time it would not be appropriate to share. 🙁 I had to abstract the problem and the code a...

Update:

J Livingston's version of Craig's version of Jeff's QU is basically the solution I am going with. Thanks again to J and also to everyone else involved in getting us...

Thanks for the extra work, J Livingston! I didn't think of updating a CTE rather than the temp table itself. As long as it follows the same rules vis a...

I was just about to post an update when I saw your reply, Craig!

My update for the day, coincidentally, was that I actually spent a good deal of time...

@jeff, in testing your rCTE code on larger data sets, it seems to work most optimally in batches of about 1000 records at a time. (And even so, I have...

Thanks to everyone who has replied already. A better group of fellas I couldn't possibly ask for.

@Eirikur: Thank you again for all your work on this solution! I have...

Thanks Craig for the considered reply. I spent a good 2 hours today reading through Jeff's QU solution and all the dozens of pages of replies and heated debate. After...

So, first off, thanks again. This is amazing to me.

I've spent well over an hour looking at this and trying to break it down into its individual elements, doing...

Thanks for the reply! Looks as if you may have cracked it! 🙂 I'll take a close look on Monday morning when I have SSMS access and get back to...

P.S. There is some added logic to do with whether subsequent sales are attempted by the original SalesRep or another SalesRep, but I'll leave that for later. Just wanted to...

Thanks, great example of how to compare efficiency of various options! 🙂 Glad to see that the most straightforward ("LIKE") is also basically the fastest.

Thanks much for the reply. Unfortunately it's a shared server, so we don't have access to full-text indexing or other special settings.

And yes, I am going to use some...