I suspect you're correct about how I'm going to end up with approaching this in this method.

Perhaps it'd make more sense if I explained the business process

The system is broken...

Basically - I need to match the person to the tier based on some user defined rules. These rules would be along the lines of tier 4 is only...

If it makes the concept easier - as personid is always present - we can remove the table and assume the data all comes from one central view - still...

yep!

and it'll be no more than 50x50 - so not a huge amount of data - this is just one small part of things, but a big headache!

ColdCoffee (1/23/2012)

---

Did the query work for...

I found the flaw in the data a little while ago.. was wondering why i kept getting a subquery returns more than 1 row of data error.

I'm out of my...

CELKO (1/20/2012)

---

>> I'm trying to display a grid on a webpage showing location.. <<

NO! SQL is a data base language; all the display is done in the front end. We...

For right now, it just needs to be returned in the SQL

While I appreciate the advise, the page you linked really didn't tell me a whole lot, except give me the indication that I'd be using a sledgehammer to kill a...

Hey there..

point taken - i thought I had enough info in there.. but rereading it.. I could have been clearer - at the bottom of my post is the create...