I'm having problem in getting a correct DTS/SQL code to store both Current_Year_Balance and Previous_Year_Balance.

For example, The figure have to compare "different figure" between "March 2003 balance" with "March 2002 balance" and so on for each following month. Later on from the "different" I get, I will need to compute the variance.

Can anyone provide me with that information. A thousand thanks!

suhfui