Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: JOIN technique

    Why not pass in XML into the SP? I.e.

    @BrandId_List XML --e.g. <Brands><id>1</id><id>2</id></Brands>

    And then your query could look like this:

    SELECT *

    FROM

    Sales s

    INNER JOINProducts p on s.customerId = p.customerId

    INNER JOINBrands b...

Viewing post 1 (of 1 total)