Hello,

I have made it quite a ways using Selects, Joins, and Grouping but have run into the final business rule I can't seem to get around. Now let me say I *KNOW* I could put this data in a table var, update it, then select from @TableVar...but I want to
see if I can make it without. In other words I want to stay "pure".

So here is the recordset:

Manuf. Loc. Group Type DaysUsed Eligible
BHG Jax A STXX 1095 N
BHG Jax B STAA 365 Y
BHG Jax C STXX 393 Y
BHG Jax D STAA 393 Y
BHG Jax E STXX 393 Y
BHG Jax F STAA 393 Y

Now the business rule says that if ANY grouping for a manufacturer (in this case BHG) runs out of eligibility then all groups are no longer elgible. So I am trying to think of a way to flip the 5 Y to N since Group A is an N. Next time around it could
be group D that causes the others to not qualify. Further the number of groups varies so the next lookup may only have two groups (A & B).

Any ideas?

Thanks

JB

**View Complete Post**

## Built-in Functions - Aggregate Functions