>>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.

I know you don't... Its okay.. I wouldn't have anticipated anything else.