• ok - adding the code.Return... enable it to run - however with no results.

    Is this right for in my sp

    C=my parameter name

    Customer=label

    Customer_Number=int value

    INNER JOIN

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

    please... anyone... thank you!