Hi,

> How do I design a Stored Procedure whose number of parmeters
> can only be determined at run time ?
>
> The situation is like this, I have an order detail table with
> the following structure at the Head Office(Data is transferred
> to branches on a daily basis)
>
> branch_id
> order_id
> product_id
> quantity
> ....
> ....
>
> There are around 40 branches and more branches will be added.
>
> If the user selects 5 branches, I need to return only the
> details of those 5 branches. So the number of parameters
> (branch_id) may vary depending on the selection of the user.

Why not do a UNION so that you can use this procedure
5 times?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com