Steve, does that mean that this thread is not a good place for me to ask about that annoying little knock in my engine between 60-65 miles per hour?

Thanks Jeff:

I realize that I've got a double thread going now, and I just had a light bulb go on when I looked at elapsed time for writing to disk,...

Jeff, this is a tremendous learning experience for me, so please hang in with me a little while longer.

I notice that you are grouping on an int...

My first thought was, "You're kidding.....", but I know you are not.

O geez.

By the way I experimented with a larger number of departments (20) and the concatenation started running a...

You're a lot more current than I am, so I'll take your word for it. Thanks 🙂

All hail The Thread.

Mighty, Mighty is The Thread.

All-Knowing, All-Merciful....

Is this the beginning of a Cult of the ThreadHeads?

(Sigh... nobody has a sense of humor anymore.)

Guys, I've learned to document code out of self-preservation... because I may be the one who has to revisit the code months or...

Ah... but you are denying them the opportunity to broaden their horizons and expand their minds by saying "What the...? How did he DO that???" ...

You don't get the speed benefits of cross apply unless the UDF is a an inline table valued function. Because an inline table valued function is a...

Jack, I can see that it would be considered advanced. I never heard about using FOR XML this way until the last couple of months. But...

I'm afraid I can't, but I will listen respectfullly to anyone who can, if they'd care to report their results. However, I see that as a different issue...

Just did, thanks 🙂

http://www.sqlservercentral.com/Forums/Topic663702-49-1.aspx

Gail, can I respond to the "doing things where they make sense" through an email or something? I think there is a case where it does make...

Sure... spoil my fun... 😉

Steve, it wasn't really a dispute. I'm trying hard to adopt...

Not true, Gail!! I even got into a dispute with Jeff about concatenation!!

Of...