Dynamic T-SQL Math
Posted on 2006-11-03
I have a table with customer number, name, and several numbers. Depending on the customer number I need to be able to add some/all of the number fields up. Every customer could be different. I could write a .Net app to process each customer one by one, SLOW. Is there any way to design this so T-SQL can do all the work? I am open to any suggestions, stored procedures, temp tables, case statements, etc. The table that will hold how to calculate the total is not defined yet, I am open to any ideas.