Never mind. The line numbers in the error message are what is misleading. The arithmetic overflow was occurring further down in the stored procedure.

I'm sorry, I seem to have confused the issue with too much detail, or maybe it was my choice of posting formum. We are going to combine the data...

Yes, ultimately we would like the codes and descriptions and facts all in the same data mart table. The real question is not "is that the best choice for...