thanks bro it worked.

thank you,

thank you opc.three. it is a great tool 🙂

thank you Lowel

true Lowell.

I have tested it on TSQL, when I declare variable as varchar , it has implicit conversion as int it has not but start showing other predicate 🙁

Hi GilaMonster,

I have attached the explain plan.

I have tuned another query and successfully convert index scan to index seek. But when I have index seek, keyLookup also came ....

this is great Lowell. it was not in my consideration .

I will ask developer.

Andy thank you. this is really great 🙂

thank you opc and Jack.

I am using return code because I will not throw error to client.

My application will hit stored porc and proc will do some processing (will execute...

thank you Ten Centuries

but how ?any TSQl code reference you have ?

Hi ,

I have got it.

Declare @rc int;

Exec @rc=spName;

Print @rc;

If rc is 0, it means success else I will have error code e.g.-6

thank you Gail Shaw

Sean Lange (5/19/2011)

I figured that when I saw

at the very top.

If you really want some help...

Welsh Corgi (5/19/2011)

thbaig1 (5/19/2011)

@col_name= column name coming rom cursor

@ColValue= will store column value

select @ColValue=@col_name

from dbo.tblBlo

WHERE Customer_no = @CustomerNumber

...

thanks it worked 🙂