Post reply

Multi Select Parameters in SSRS - SQL School Video

  • October 20, 2008 at 10:12 pm

    #63584

    Comments posted to this topic are about the item Multi Select Parameters in SSRS - SQL School Video

    Brian Knight
    Free SQL Server Training Webinars

  • October 21, 2008 at 1:37 am

    #887456

    Bah 🙂

  • October 21, 2008 at 6:19 am

    #887546

    Brian,

    Thanks these are a great help!:cool:

  • October 21, 2008 at 8:21 am

    #887608

    This was a nice presentation, however, I may not be alone in being locked into stored procedures as a data source. The consultant who assisted us in setting up the data warehouse was adamant that good practice was to never write a query directly in SSRS. When passing a multi-valued parameter string to a SP, one additional step is necessary to parse the query string. I am sure there are a number of satisfactory ways to handle this. I use a function call from the SP to parse the parm string to a table.

  • October 21, 2008 at 12:04 pm

    #887770

    Biran,

    Thank you for sharing these videos with us. I have been really enjoying them. Sometimes it's hard to find the time to read a long article, but with a video I can see exactly how much time I will need and you manage to cram a lot of useful information in these few minutes. Keep up the good work! (btw, I own a few of your books too 🙂 )

  • March 12, 2009 at 3:01 am

    #958131

    While the video might be useful, I agree that it's good practice and much cleaner to use stored procedures. If you can show me how to do multi select parameters with stored procedures, I'd be really impressed. I've been battling with this for a while now.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply