Session
The New PRODUCT Function in SQL Server 2025
After years of waiting, the counterpart to SUM() has finally been added to SQL Server! PRODUCT allows a set of values to be multiplied together.
This may seem absurdly simple, but it allows for some messy and complex calculations to be simplified. As a bonus: performance for PRODUCT is far better than legacy alternatives.
If you have ever had to calculate interest, percentages, complex mathematical series, or statistics, you may have been forced to work around the lack of a PRODUCT function in arcane and scary ways.
No longer must sorcery be used to solve math problems!
Edward Pollack
Data Architect | Microsoft Data Platform MVP
Albany, New York, United States
Links
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top