Mangesh barmate

Mangesh barmate

  • NA
  • 118
  • 136.7k

how to get value by passing multiples value in T-Sql ?

Feb 7 2013 9:19 AM
Hi,
I have a table which has 2 columns namely PlanId and RiderId in below format-
Query is- I want pass multiple riderid and i want to get PlanId on the base of multiple RiderId.
In this case i will pass 327,329,330,326,355.
But 327 available in 2 times in planId column having 356349 and 356347 but here i want only one PlanId which is 356349 , because it hold combination values. How i accomplish this.

PlanId  RiderId
356348  330
356348  355
356348  327
356348  329
356349  327
356349  329
356349  330
356349  326
356349  355 

Answers (1)