Sorry it isn't the account (monetary) balance i'm referring to, it's a balancing figure, calculated by: 

[Number of Accounts Opened] - [Number of Account Closed] = [Remaining Number of Accounts...

Yes I agree, the structure is not ideal (I can't change it), however an account does only have one opening and closing date per CustomerID. 

In terms of desired output, it...

Do you have any useful info on calculating multiple linear regression with T-SQL?

This is excellent. Is there any way to take it a step further and input the password into the 7-zip file, and set any of the 7-zip file options?

Thanks

Hi Rob,

Thanks for your quick response. I'm new to SSIS and I don't think I explained enough earlier. I want every record to be included in the destination import, with...

I should specify, that my drop down list of dates is exactly that, NOT a date picker which I would like to achieve with UK date format.

I am using SSRS...