I'm thinking that just a little irresponsible on your part.  Good night, Lynn.

I agree that good teachers work themselves out of a job with their students... the point is that you misread the question and provided an incorrect answer.  Thank you for...

Good teachers are always responsible for the outcome...

Folks, go back and read Vladan's post... that's the only correct way to do it.  He explains "why" quite nicely, too.

Careful... that, too, will likely cause a table scan because the column in the WHERE clause is contained in a formula...

Well, when folks post such detailed information about how their code works (very nice job, by the way), others take the code and just use it instead of analyzing it. ...

Sure, that's what he said he thought the logic should be... he said immediately after that...

"Is the logic correct?  Can someone please help me decipher...

Thought this was what he asked for...

"certain action items need to be automatically assigned (through code) a due date on 3 Wednesday’s from whatever today is.  "

I agree, the 14...

...except, it doesn't work... if today is the 10th of November, 2006, the 3rd Wednesday from today is on the 29th of November... not the 6th of December...

SET...

Here's an example I made for the boys at work... the Customer Table has about 1.2 million rows in it... page "0" (page 1) will return in about 16 milliseconds. ...

Len, the following will prevent an index from being used if one is available...

where convert( varchar(10), DateField,112 ) between @T1 and @T2

Papillon,

Would you post the query that makes the output, please... there may be a trick or two we can pull off on this one...

Do you have an example?

And, be aware that because the code uses a global temp table, you should do something to guarantee that only one instance of the code will ever be executed at...

Robert,

Shifting gears a bit, how's the performance of inserts of new records?  How about for a returning customer with a new order?  Your clusterd index is VERY contrary to the...