Is there any benefit to using one of these over the other?
AND (r.resolve_status = 0 OR ISNULL(r.resolve_status))
AND r.resolve_status IN(0,NULL)
I ran a query through an online “tuner” and the only recommendation was to use IN instead of OR. I can not find any documentation on this, but then again searching for variations of ‘using or or in’ may not have been the best approach.