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
Loading
Jignesh TrivediPosted Feb 7, 2013, 11:03 PM
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.