durai nagarajan (11/19/2012)
Nolock is not used.we havent used inbuilt function also.
there is date conversion and comparison between a table column and input parameters.
i forgot to mention it is compared with a encypted column also.
anu suggestion based on above details.
can you post the Sp definition here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)