Welcome to WebmasterWorld Guest from 54.158.35.222

Forum Moderators: open

Message Too Old, No Replies

Help getting one return from multiple rows

     
1:10 pm on Jul 30, 2010 (gmt 0)

5+ Year Member



I'm trying to get one row returned for a display of a public phone extension and I'm just not seeing something clearly. I want to check directly in my query that if someone has multiple extensions to only get one based on rules:

A person can have up to 3 types

7000 range is for voicemail
3000 range is for direct
5000 is a boss group (rings multiple phones, ie secretary)

A few administrators that have been promoted through the years started with just voicemail, then got a direct extension, then got a boss group, so I have a "worse case" with them that could look like this:

Name|Ext
------|-------
User | 7140
User | 5620
User | 3259

The rules follow:

If someone has a 5000 range, get that one as 'Public Extension' else If they have a 3000, get that one as 'Public Extension' else get 7000 as 'Public Extension'. Is this possible to do directly in the query?
3:38 pm on Jul 30, 2010 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



If they have all 3 (or 2 of the 3), which one has priority?
4:16 pm on Jul 30, 2010 (gmt 0)

5+ Year Member



The 5000 range number
 

Featured Threads

Hot Threads This Week

Hot Threads This Month