>>>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.
Ok then.
If it's not broken, fix it until it is.
My Blog