Viewing post 1 (of 1 total)
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...
December 7, 2009 at 9:38 am
Viewing post 1 (of 1 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy