Thanks for ur repsonse

Actually my query goes like this

Select Max(InpassNo) from TbInpass where CompanyID='FF' and Finyear='2005-2006' .

The fields InpassNo,CompanyID and Finyear are Primary keys.But still its performance is not good....

Thank u for ur help.I will surely get ur help for my future sps.

Although we generate code , will that not be too many lines of code Remi?

Rohini

Thank u Remi, this worked out.

But imagine if i wanted to pass 25 parameters to my stored procedure and wanted an output parameter,then how long will be my calling the...

This page came just when i clicked the 'discuss about this article' after reading the article 'Using Parameters with Stored Procedures' today.

The stored procedure has output parameters and eg. was...