Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Using XML to pass Multi-Select parameters from SSRS to SQL Server RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

  • May 8, 2008 at 2:41 pm

    #812702

    this is what I have in my sp

    INNER JOIN

    @C.nodes('/C/CUSTOMER') as m(item) on cast(CS.CUSTOMER_NUMBER as int) = m.item.value('CUSTOMER_NUMBER[1]','integer')