>Well it wouldn't have been so back and forth had Naomi said everything in her original question. I think the reason is that its faster to query the collection in memory than to execute an sp. LinQ is a phenomenal product. Sorry you don't see it.

My original question contained all the correct information. I don't see why you're saying I was changing parameters.

I posted the T-SQL query I wanted to convert. After a bit of a struggle and looking into various posts online I've been able to come up with the working syntax. You helped to realize to use the from version of the LINQ.