Yes, we already covered this. If you check my previous points you...

You should note of course that this a SQL2005 forum, so everyone posts answers on that assumption. Also, it is an amazing coincidence that you managed to have a...

Thats kind of odd, because with 135 CASE clauses, you should be able to use about 50-55 characters per case clause safely. Can you show us the actual command...

Another question: is this a 64-bit 2xQuad Core server running SQL 2005?

Just checking: Do you have MAXDOP set to 1 already? And Hyperthreading is turned off, right?

Whoa, CXPACKET is big.

Heh. Steve probably lets Jeff have "special" code windows. :w00t:

Be sure to let us know how it worked out.

Absooo-rutrey!

Tables are sets of tuples, so all of the SET operators work on tuple-sets.

So EXCEPT and INTERSECT work on multiple columns, just like UNION does.

So that's in-between LGD and Cryptographic? And I don't see any varbinary(MAX) or sql_variant data-types. 😀

Thank goodness too, or I never would have gotten there!

Heh. 😛

Jack:

We have couple of clients who have a very similar setup (they are charitable religious foundations) and Matt has it right: As long as you have CPU-based SQL...

If you are experiencing the problem now, can you try this query and show us the results?

Select * From

(Select DateDiff(ss, Login_Time, Getdate()) as ConnectTime,

Cast( Cast(CPU as Float)/1000000 as Numeric(12,3))...

You know, I dont know how we could have missed it, but looking back over the information provided, I do not see any execution plans? Also, the table definitions...

OK, that's cool.