I have a table where it holds data by .....
Company Division Date Manager
there are many companies each with different divisions and a Manager could be in any company or division on any date. They can change by date - that is they could be in Company A and Division Z in one month and not the next.
I would like to know how I can show the "additions" in one sql query and "deletions" in another sql query of manager in each Company - then Division by each month.
So, my output would read something like ..
Date Cpy Manager Divisions
Jan 2013 A Barry J Z
Jan 2013 A Dave S Z
Jan 2013 A John D Y