I have a query to calculate sale total for each group group by several sales group.
I have the following groups
Now I want to merge Education group and Reseller group as Reseller group and sum them, remove the education group.
How can I do that in a query?
I am in MS sQL 2008 R2 env, and this is for MS SOL 2008 data warehouse report - SSIS