Hi,
I have a query and want to pass multiple column values as a parameter.
for example i have below qquery where i want to pass multiple values instead of one value-
SELECTDISTINCT prs.RiderId
FROM [dbo].[PlanRiderSet] prs
INNERJOIN [dbo].[PlanProductSet] pps
ON prs.PlanId= pps.PlanId
innerjoin [dbo].[PlanRider] pr
on pr.Id=prs.RiderId
WHEREpr.RiderIdNumber=604 –Here I pass value like multiple means '604,601,605,703' like this values are in table column values.
and pps.ProductId= (SELECT pps.ProductId
FROM [dbo].[CustomerXref] cxref
INNERJOIN [dbo].[CustomerPlanXref] cpxref
ON cpxref.Id= cxref.PlanXrefId
INNERJOIN [dbo].[Plan] p
ON p.Id= cpxref.PlanId
INNERJOIN [dbo].[PlanProductSet] pps
ON p.Id= pps.PlanId
WHERE cxref.PlanXrefId= 3598)
ORDERBY prs.RiderId
HOW i ACHIEVE THIS!!!