You have too many fields in your GROUP BY.  Specifically, you should not have B.Sales_Date.  If that still doesn't help, follow the directions for posting sample data and expected results...

It's been a long time since I worked with SSIS, but we actually used a table/view to do our configurations.  The table had a field for server name and the...

I don't know about SSIS, but SQL will automatically convert TRUE to 1 and FALSE to 0 when assigned to a bit field.

Drew

You can actually simplify this.  There is no reason for the nested CASE expressions and you can greatly simplify the sign.

I'm assuming that CONFIG.PremiumSignShowData is both a BIT...

I got it to work.  Here are some of the changes that I made.

1. I added another column for the sort order.
2. I added a CTE to calculate a DENSE_RANK...