The table is used for reporting purposes. The account table holds information about account balances at a certain date (target_date). So, if you want to see how the...

I ended up rewriting the view. Where I work, they love to pile view upon view upon view. That seems to be the biggest problem with sql server....