You're absolutely right, JacekO. There's nothing left to be said on the subject except, from what I read, you are the only person you proved your point to. I didn't...

Lee,

You can also nest IF...ELSE statements and CASE statements. It could be...

JacekO (3/19/2009)

---

The SQL Server transactions can be called nested transactions but they are not. Plain and simple. If they were nested they should work the way I described. There might...

Lee,

Before I go any further, Label 1 confuses me.

label1:

-- 1st check - do we have a customer record in CP

IF EXISTS (Select * From DATABASE.OWNER.TABLE 6 WHERE cust_id = @memvar...

JacekO (3/19/2009)

---

From my point of view they are not nested but maybe I could call them chained. To explain how I understand the term nested I provided an example...

Ah. I forgot local help could be disabled.

But shouldn't he still be getting something from the online stuff, assuming he has a network connection?

Wow. That's a new one.

You say it was working before?

Has anything changed since then? Any programs removed from your box? Anything added (service packs,etc.)?

Check Windows Explorer and see if you...

Nesting is a broad term. You can nest triggers, stored procedures, transactions, IF..Else statements and loops.

Basically, a "nest" is when you embed one thing inside of another and the internal...

I should also clarify that I don't advocate nested stored procedures (which is different from nested transactions).

I've never had any reason to use them, though, and I know of at...

Lee,

I think you misunderstood me. Nested transactions can be wonderful things, if you need them. If you don't, I don't advise indulging because it's a lot of wasted effort.

What I'm...

At this point, you need to contact the help desk of your third party mail server and maybe even engage Microsoft in the problem. It sounds like an issue on...

I know you said things are working fine, but curiousity just struck.

Did you create the MP while your SQL Server was at SP1 patch level, then create the new job...

Another way, if that doesn't find everything, is to use NOT IN. However, you should be aware that NOT IN uses more processing power than an IN statement.

So:

Select * from...

Hee! True. @=)

Everytime I run into this issue, it's because I'm either using an = sign with a date...

Finally catching up to this thread, now that I have a break from major projectness. Sorry, Lee, that I wasn't able to re-respond earlier.

As far as JacekO's (I think it...