>>>something like this. Not tested.
>>
>>Hi Boris,
>>
>>I got a link to this article by e-mail today
>>
http://www.sqlservercentral.com/articles/T-SQL/66030/>
>I didn't see an example with TABLE VARIABLE and w/o Clustered index :-)
>Kill me I don't know how to get the results that guy get. I see the actual execution plan but didn't see anything like his results.
I'll play a bit tonight, but just from the reading this article it seems like a very clever approach. Now I want to say "dah"... :)
If it's not broken, fix it until it is.
My Blog