Try this AND (CASE WHEN ErrorID >= @ErrNumStart OR @ErrNumStart Is Null THEN 1 ELSE 0 END) = 1 I am just curious what effect it has. Is the code in an SP and have you looked at the execution plan to see how compares without the line.
2003-05-19
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers