To the lovely Shawn: d_sysuk: dude you just don't get it do you?

--> Stop posting, we're fed up:..had enough of this yesterday.

Advice: STOP READING POST !

I like many others do...

Well going to the first post, its clear the the post is most unclear in its requirements. Shouting at posters wont help under any circumstances or imposing random conditions...

These eyes may be failing, but whats amazing is my poor ability to read english here. Its easier to explain things with input, output , result... See below for...

There is a more subtle point, Im making in the query plan optimisation that is saved.

A greater man, than I has quite nicely explained this , have a quick look...

There is a big difference in writing :

>> Unoptimsed SP method for lookup using local var

create procedure mysum (@myid int)

as

declare @myint int

set @myint= @myid

select x,y,z from mytable

where mylookupfilter =...