tag:blogger.com,1999:blog-8511988205422549424.post2662576577361641395..comments2014-03-25T04:59:24.857+11:00Comments on BI-tch: Reporting Services: Passing MultiValue ParametersKristen Hodgeshttp://www.blogger.com/profile/02708872213558099042noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8511988205422549424.post-20958226806733669632009-10-28T06:17:09.759+11:002009-10-28T06:17:09.759+11:00To do this in a SP try this
where charindex( prod...To do this in a SP try this<br /><br />where charindex( productname , @ProductIDs,1) > 0 <br /><br />-- Link @ProductIDs to your Report multivalue Parameter<br /><br />GlenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8511988205422549424.post-86675967624517893492009-05-25T21:23:50.984+10:002009-05-25T21:23:50.984+10:00This method of passing multiple parameters to a co...This method of passing multiple parameters to a complex procedure improved performance on our database significantly. Try it and test for your query before discounting this method.NicMeneseshttps://www.blogger.com/profile/12794370642951365131noreply@blogger.comtag:blogger.com,1999:blog-8511988205422549424.post-67275516938143499852008-06-25T06:25:00.000+10:002008-06-25T06:25:00.000+10:00I've implemented this and compared it to the query...I've implemented this and compared it to the query run as text and the performance was unacceptable. It was nearly three times as long to use the XML join in the stored procedure.Anonymousnoreply@blogger.com