• sharonsql2013 (2/11/2015)


    My Store proc has the where filter with an in clause

    where abc in (@xyz)

    However while executing , Can I pass multiple values?

    Exec usp.Planner @xyz = ????

    As your procedure already has where filter with an in clause. Just pass multiple values as comma separated to you parameter.

    Exec usp.Planner @xyz = 'a,b,c'

    ____________________________________________________________

    AP