Ok, Lisa... you just assumed that I knew you were talking about the "other" code in your rule of thumb and I thought you were talking about the code I submitted...

1. The order will almost always be determined externally to this expression anyway, since unless you can guarantee < 12 months and all in the same calendar year you might...

Ian,

Nice job at producing the return that the original poster actually asked for... there is one little problem... you cannot include the ELSE clause that you have or you get...

Even though their occurance is really unacceptable, deadlocks are about as normal (I didn't say "as frequent") as regular locking anytime you have both a SELECT and an UPDATE in the...

I'm thinking that formatting the message is much less important that formatting the code for readability...  It only took about ten minutes to...

Forgot something else... if you parameterize the table name for the small names table, you can pass a parameter to use different name tables... that will allow you some extreme...

You might also want to remember that the minimum resolution for the DateTime data type is 3 milliseconds, not 2 as posted in the original code.

It would appear that Isa want's to manufacture data (for test or otherwise) with a random number generator for the "Aro_ID" column.

Isa, one question that remains is "Can there be...

OK, Bruce... here you go...

You were worried about the performance of a cross-tab (aggregate functions)... as some have suggested (especially Serqiy), that really shouldn't be a concern.  I know... you've...

Jun,

Crud... Dan's right... sorry we got off track...

To reiterate Dan's question, what should the output look like?

That'll do... I was just worried about the fact that you said it uses "recursive search on Customer table".  To me, recursion is when a proc or function calls itself......

That's why "trick" was in quotes

Unorthodox?  If you think about it, the table structure is similar to that which XML offers (thought everyone but me loved XML ) but...

You can have millions of recursive calls so long as you don't exceed 32 levels of nesting... same as number of nested triggers, nested stored procedures, etc.  Write a function...

It is if you make it table driven for the days of the week based on language...

But I get your point... to be portable, you would have to use one...