Results 1 to 20 of 20

Thread: [RESOLVED] stored procedure multi-select question

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2002
    Posts
    150

    Resolved [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
  •  



Click Here to Expand Forum to Full Width