GAH.

I hate having a SSIS package fail and fail again when being run from a job, but works fine from the desktop. And I look and look and...

I'll look into decision tables. Thank you for the suggestion, Joe.

Scott, I appreciate your input, but I want to make a non-code based solution if possible. The reason...

Am I really the only one annoyed by Mr. Ansi's "Please post DDL and follow ANSI/ISO standards when asking for help." response to the debate when the question didn't even...

WHEE!

Just got a text from my mom, who is watching the munchkin.

Guess who just figured out how to do that silly clapping thing Mommy &...

In retail, people are taught to be honest when they don't know something but also to follow it up with a promise that they will find out and...

Okay, so I do have an additional question. Why use the specific WHERE clauses you've used? Why not test the NOT IN with specific values?

Why are you using...

I've never actually played with EXISTS / NOT EXISTS, so I should probably try it out and see if it helps with our ITD feed processes, which are taking longer...

So basically I am looking at a table to store all the possible combinations in.

I want to avoid a function if possible. I'd have to call it inside...