Home Forums Reporting Services Reporting Services Delcare variable for Multiple values paramter in SP ??? RE: Delcare variable for Multiple values paramter in SP ???

  • December 5, 2013 at 3:16 pm

    #1671332

    Michael_Garrison (12/5/2013)

    Yes, read this article. I had to do learn same thing regarding multi valued params and stored procs. Using the JOIN and then in the stored proc code, use a split string function when values are passed in. something like:

    ld.ORIGINCITY IN (select * from [dbo].[fn_SplitStringList](@OriginCity)) Can search for a splitstring function in google, there are plenty of them.

    And you can find the best (no-CLR) splitting function in here: http://www.sqlservercentral.com/articles/Tally+Table/72993/

    Read the article and the comments for the best performance and test it yourself.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2