Mangesh barmate

Mangesh barmate

  • NA
  • 118
  • 135.8k

How i pass multiple values into the where condition column ?

Feb 8 2013 4:33 AM

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


Answers (1)