-
May 2nd, 2006, 12:12 PM
#1
Thread Starter
Addicted Member
[RESOLVED] stored procedure multi-select question
hi,
is it possible to design a stored procedure to expect unknown number of parameters.
for example; I have a select statmenet that retrieved number of records based on what the user selections. so user might select 1 record or 10 records to show. I want to convert the select statement to Stored Procedure but I can't specify the parameters in the stored procedure becasue I wouldn't know how many the user might select.
what is the best solution arround it??
in my select statement I build my Where claus based on the user selections so it would be " id=1 OR id=20 Or 23 Or......" and don't know who to do something similar in stored procedure if it's possible at all....
thanks everyone,
Last edited by Hack; May 5th, 2006 at 06:05 AM.
Reason: Added green "resolved" checkmark Last edited by waely : Yesterday at 03:12 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|