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...