Schadenfreude: Your best entertainment value.

Here it is. Many dark and arcane secrets buried within it.....

Seriously, I'm sure you will have questions. First run it, and let's see if it does...

I think I see what you're driving at, and I think we can get it done in one step without an update. Hang on and I'll see if...

The word is "conceited". Conceded is something you should have done days ago. Sorry, I couldn't resist that one. 😉 By the way,...

No problem. 🙂

Here is a revised version that includes a batch number. Please just run it and look at the results, then I can answer specific questions about...

If you have a sequential row number column in #tempAA you can update it using the following CTEs.

Can you show us the create table for ##tempaa and maybe some sample...

Time be time. -- Maelcum

It's now DBCC TIMEWARP. It takes 127 parameters, none of which are documented anywhere. Most of the parameters are for detailing your exact position in the space-time continuum and your...

Point taken, Jeff.

Time

And

Relative (Relational?)

Distance (Dimensions?)

In

Space

"We're running out of time!"

"Don't talk to me about time. Time is my business."

[Now I've got the theme song running through my head.]

Glad I could help. CTEs are a good thing. I prefer them to subqueries because they read from top to bottom, which is more intuitive...

Hey Alvin

In fact, I am coming up to Memphis Thursday night. Expressly to attend the PASS meeting. Our head DBA used to work for FedEx...

Thanks to you too, Chris.

Gail, I have been answering questions for some time now, and hope to continue. But with the evolution of The Thread, I've rolled up...

Thank you Gail, I will look for them in Memphis at first opportunity.

Lynn, continuing the casual conversation from the rant thread, I live in Oxford, Mississippi which is about an...

Knock rings about what? (This is not a sarcastic question, Jeff.)