How to calculate the product (multiplication) of a set of rows in SQL within an aggregate statement. So lets say Quantity of row 1 x Quantity of row 2 etc.
From the site:
"MyProduct: Exp(SUM(Log(SomeNumberField)))
This can fail if your numbers get too big. Your maximum value is the size ...
How to calculate the product (multiplication) of a set of rows in SQL within an aggregate statement. So lets say Quantity of row 1 x Quantity of row 2 etc.
From the site:
"MyProduct: Exp(SUM(Log(SomeNumberField)))
This can fail if your numbers get too big. Your maximum value is the size of a double."
