I doubt I'd use a list of threads originated. I tend to try to help if I think I can, regardless of past circumstances. I most certainly don't...

Order of columns in Group By doesn't matter. Presense or absense, yes; order, no.

steve dassin (4/6/2009)

---

Sergiy (4/6/2009)

---

Such a...

The conditions you're asking about are the ones I included in the Case statement. Those tests will accomplish the same thing as all the various left joins and unions...

Try this, tell me if the function works any better this way than the way it's currently built. I can't test this, since I don't have all the table...

It would be very helpful if you posted the create scripts for the tables the function references, and insert statements for some sample data for each of those. That...

I don't build my queries that way, so I've not seen that. I just type them out myself. I've had so many problems with the graphical query designer...

Jeff Moden (4/6/2009)

---

Here's a perfect example...

http://www.sqlservercentral.com/Forums/Topic688949-8-1.aspx

My answer would have been... "Thanks for the setup code... please post the code that you've tried so far so we can point you in...

If I understand what you need, here's an example that seems to work:

-- Set up test data

create table #T (

ID int identity primary key,

Col1 varchar(100),

Col2 int,

Col3 datetime,

Col4 datetime,

Col5 int);

insert into...

Jack Corbett (4/6/2009)

---

I agree with the facts that it could be a legit business requirement and that using a table to store the times would be the way to go....

I try to set a relatively low threshold for what I expect from a question before I'll try to answer it. Or, to put it another way, I try...

If you had a situation where data updates (insert/update/delete) were supposed to have a specific result if done at a certain time, then a trigger with a "run at this...

I wouldn't have been able to answer the question about a Halloween Problem. Never heard of it till just now in this thread.

If it had come up in an...

There are plenty of rules that "must be followed" every time. Most of them are the ones built into the language.

There are a few that I follow with tremendous...

Chris, on the case-statement version, running on the same hardware as the prior tests, took 8:59 (nearly 9 minutes) the first run, 8:54 the second.