Forgive me for wasting your time. Someone had started adding code into my proc with an IF statement, and hadn't closed it or commented it out. What a...

Sean Lange (12/14/2012)

---

I will second Phil on the NOLOCK. That query hint is by no means a go fast pill. It is a get your data quick as long as...

Thanks, Phil. I thought NOLOCK prevented table locks, and made the code run faster. Is that not the case?

Also... doing the subqueries with "With X as" instead of...