Pstttt....

It's "rude and obnoxious" or "LEWD and lascivious."

To paraphrase Inigo Montoya:

"You keep using that word. I do not think it means what you...

I couldn't resist... 😛

I've used SSIS to:

1. rethread particulate data out of a table and back into itself to avoid locks due to trigger overlap

2. derive up to 137 parameters for...

Post is this commutative?

I refuse to dignify that with a comment that I have edited to make Lynn curious.

I second ColdCoffee's motion. Sample schema with scripts to populate them with sample data and a picture of expected results are what we need to give definitive (even...

My eyes walked right past that. Time for new glasses. Thank you for pointing out my error, Tom. 🙂

Got it. That is the first time I've seen this trick, and it's a clever variation. Thanks for sharing it. 🙂

I just tested the both...

Jeff, my example used daily reports, not monthly like I kept saying, but I didn't change anything about the runtimes. Here is what I posted and what I meant.

If...

IBM S/32-38 used the 8 inch floppies (originally called diskettes, but I believe the French found this somewhat inappropriate.) They were a GREAT improvement over decks of...

Could you post up some working code that uses CHARINDEX?

I'm not sure I understand how that works or what it will do for you.

Absolutely, it depends. ("It depends, it depends." sounds redundundant.)

To me that means the same thing as "It's a judgment call." What I'm curious about is...

That argument ignores the context, the concept of opportunity cost, the concept of diminishing returns, and the value of human time. All it does is use the ancient dialectic...

It will also server as a better example of how to write code in the future so that when someone copies the code because "it's close to what is...

All of which are dependent on your alternate reality ID (ARID) value.