Hi,
What is the best way to handle situation in which number of paramters to a stored procedure or sql statement may vary. Currently I have a user interface for selecting multiple columns from different tables. I want to pass this information to a stored procedure or build an sql statement. Any feedbacks would be appreciated. Thanks,

paul.

The number of parameters to a stored procedure is fixed when the procedure is created. There is no concept of a variable parameter list.

Parameters can be optional, though. You can define a default value for a parameter if the value is not supplied when the procedure is called.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

So i guess it might be a better option to use sql statement because number of parameters may get huge. Or i could use sp_executesql.

http://www.algonet.se/~sommar/dynamic_sql.html

regards
David Cameron