Click here to Skip to main content
11,573,084 members (64,716 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
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
Posted 7-Feb-13 3:16am
Edited 10-Feb-13 23:58pm
Maciej Los186.5K
v2
Comments
skydger at 7-Feb-13 9:48am
   
What query do you use?
Without knowing structure of your tables no one could help you. Please improve your question and tell a secret of your 'plans' table which holds relation to magic 'combination values'.
Sheikh Muhammad Haris at 7-Feb-13 14:04pm
   
What is you Combination Value logic? Why do you want to select 356349 ?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,

I think you want to use GROUPS, let's see if I understand:

SELECT
    YourTable.PlanId
    ,YourTable.RiderId
FROM
    YourTable
GROUP BY
    YourTable.PlanId,
    YourTable.RiderId
HAVING
    YourTable.RiderId IN (--your inputs here)
    --Example:
    --YourTable.RiderId IN (327,329,330,326,355)

Hope it helps
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Write stored procedure[^], like this:
CREATE PROCEDURE GetPlanIDByRiderID
    @riderids NVARCHAR(1000)
--example input: '321, 322, 333'
AS
 
SELECT PlanId, RiderId
FROM YourTable
WHERE RiderId IN (@riderids)
ORDER BY PlanId, RiderId
 
GO
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


Advertise | Privacy | Mobile
Web04 | 2.8.150624.2 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100