• Good question. I almost missed it because I didn't notice it was loading a table variable at first. I was saved because I remember the previous question that seemed exactly the same and almost answered the same way. I knew there must have been some difference so I looked closer at the query and then noticed it wasn't an actual table but a table variable instead. Whew! Close call on that one.

    Lesson learned: Pay close attention to the details.