Forum Discussion
Calculate Product during Support Call
Hello, I have 2 very large tables that bog down SQL when I attempt to create subqueries to calculate which product was in place in our billing system during a call in the support system. I am hop...
I relalize that I only put in one service number, of course we have many service numbers and the calculation will need to match the service number then the max date that is less than the support call date and return the product.