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

Question

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 327329330326355. 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

Jignesh Trivedi · Answer

hi To accomplish this you may use table value parameter with SQL server 2008. please refer below link http://www.c-sharpcorner.com/UploadFile/ff2f08/table-valued-parameter-in-sql-server-2008/ http://www.c-sharpcorner.com/UploadFile/ff2f08/table-value-parameter-use-with-C-Sharp/ hope this will help you.