>hi!
>
>will u plz tell me that, is it possible to have input parameter in the stored procedure like this.
>
>SELECT @MAX_NO FROM @TABLE_NAME
>
>where both @fields r input fields.

No. But you can build the select in the stored procedure (I don't suggest as it opens the gate to some security known as "SQL injection" - to say it simple you're making your databases guardless. Hackers would love that).
Cetin