If you do not require NULL values you could go to SQL Server and select the table and field of interest. Then assign a Default Value of 0.
True, that would also work for the situation that he described - I was thinking more along the lines of both his current situation as well as instances of outer joins involving accounts with no transactions.