dj1202 (8/6/2012)
After further review, I believe I understand your recommendation now. Are you suggesting that I input NULL or 0 values in the table, for all the location groups that currently do not have a value?
That or create a table that houses all available location groups, then do a left join instead of an inner join. I used to do this by creating a temp table or using a cte to gather all distinct values if it is dynamic (getting all products from a product table that are still active products), or just build a table if it is static (months in a year).
Jared
CE - Microsoft