I believe so as I dont have any other connections open.

Maybe I rolled it back and don't remember that I did. Confused now. Anyhow......... Thanks for that information, its...

Lynn is right... you are reading these posts out of context. Its as simple as 'Stuff' 😎

Nice, it works like a left join but very simple. Thanks... I'm still looking to see if this solves my problem

Pradeep,

Thanks for the article. However, I wouldnt be able to do this within a stored procedure or would I ?

-

S

Wow, that is nice. I had no idea such a thing existed. I need to note this down. Thanks for the valuable information.:cool:

Awesome, thanks for all your help. Really appreciate it.

One more question actually.. I just thought of this.

Could I put all these updates and inserts in one TRY / CATCH block?

Great, thank you so much for the help. I have changed my query to the above.

Also, I think the "OR" does seem to make more sense as its always better...

Thanks so much. That makes total sense. I'm not sure why I'm using the IF statement... Can I just run the update and then the insert?

Btw, i'm trying to check...

😎 Definitely closer. I just ran it and it returns all the result options such as:

StatusID = 9 And StatusDetail Empty (Twice for some reason)

StatusID = 9 and StatusDetail NULL

StatusID...

Not sure what you mean. If you mean my logic is wrong.. I'm thinking the same. How do I correct it?

Sure, Slange. I'll post here in a minute.

Adi,

I'm thinking if I shuold be using an IF statement instead of a CASE WHEN? I just want my query to be more dynamic than currently and be able to...

Slange,

Doesn't work. I'm not trying to do a simple select, I think i'd be able to figure that out myself :-P.

I'm trying to select based on a criteria.

What happens is...

Okay figured it out ;)... below is my final query:

IF NOT EXISTS(SELECT [Server] AS ActiveDirectoryServerName,

Enabled AS IsActiveDirectoryCommunicatingWithDocLink

FROM LDAPConfiguration

WHERE [Server] = 'OBI-WAN'

AND Enabled = 1)

EXEC msdb.dbo.sp_send_dbmail

@profile_name= 'Omairs Email',...