The fact that I used a prepared statement may have been the cause of the missing SELECT in the Profiler's Plan. And yes, I am coming to the realization that...

This may be my inexperience at work. I got the Plan from the SQL Server Profiler output. I just right-clicked one of the "Showplan XML Statistics Profile" rows and selected...

Strange - I thought I had attached the Execution Plan and the table's DDL. The query is in the text of my original post, and I have now attached the...