Erland, great! Thank you. I was misremembering the default locking; it's been years since I've read about that and Sql Server & DB admin and programming is obviously not my...

Sorry, I know I'm...11 years late to the discussion, but in the original example, why is the condition even necessary? Why not just set FMTONLY OFF every time?

Great! Thank you. That all makes sense. The norm is for my RLS policy's filter function is to filter on facilityID and IsDeleted=0, but either of those can be optionally...

drew.allen (9/26/2016)

---

Luis Cazares (9/26/2016)

---

drew.allen (9/26/2016)

---

xr280xr (9/26/2016)

---

I don't specifically care about short circuiting. I just need to only evaluate b if a is false and only evaluate c if a and...

drew.allen (9/26/2016)

---

I was also wondering if instead of mutually exclusive you meant disjoint. Mutually exclusive means that you want to exclude the intersection of two sets, whereas disjoint means...

Actually, your expansion of a || b || c is incorrect. The correct expansion is

a AND !b AND !c OR -- you need to add that both b and...

Selecting into a temp table first is not a solution. When your cursor selects the data back out of the temp table, there's no guarantee it will be in the...