i want to fetch all the branch_code having all the products in the Requested Product table ..
the number of products in Requested Product table may change dynamically..
i am passing product code from a single parameter through a stored procedure ....
how to split the parameter inside SP and create filter condition like
"select 1,2,3 from stock where product_code='p1' and product_code='p2' and product_code='p3'................."