durai nagarajan (11/16/2012)
Note: that SP is not giving wrong output every time.
Here do you mean that with same parameters you are getting different results (sometime right sometmes wrong ) ? any inbult function like getdate() OR RAND() fuunction used inside ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)