You're welcome, Squidder.

Please take a moment to look at how I set up the problem. When you take the time to post...

The following code will give you the same result, but I don't think it will change your performance. The execution plan is pretty straightforward, and appears to...

Other questions:

How do you get the rows without the joins?

How big are the tables you are joining to?

Are the joined tables indexed?

What does the query execution plan look like?

Joins can...

You're quite welcome, Seth. 😀

I'm really surprised to hear you say that, Lynn.

Oh wait.... I thought that said cursING. 😀

I'll echo Lynn, how have you approached this problem? Also, you will find that online forums are not geared to...

Yes. Here's one way.

Depending on the volume of rows that you have to update, there may be more performant solutions.

declare @sample table (RecID...

ISP = Insane SQL Posse ??

So you want to ignore November 1st because it was a singleton?

Here is a modification of the example from Books Online. It is really quite simple, which leads me to ask why you are looking for another way...

By the way, Adam. I thought you said that you didn't have time to keep up with The Thread about a dozen posts ago. Be careful,...

Woods are good. They provide fuel for fire and draw game to your vicinity.

You...

Apparently plagiarism detection has become quite the cottage industry. Search "plagiarism detection" and you will find a number of different offerings.

What Jeff said. The problem is finding the documents out on the web to compare. I've heard that many schools subscribe to a service that...