CLR-based function library for SQL Server that adds 31 windowed / cumulative functions that can be used directly in queries.
SQLRollingStats extends the T-SQL scripting environment with 31 windowed or cumulative functions (in which results for each row depend on previous rows) that can be used as regular functions in queries.
This allows metrics such as running totals or moving averages to be easily calculated within simple queries - something that has hitherto been a significant challenge in SQL Server.
All the functions support windowing (such that only values from the last n rows are included in the input set - where n is the window size), cumulative operation (where all prior values are counted), and tiling (so the accumulation is restarted for each distinct value of a given column).
Functions include:
- Sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous.
- Average (mean), variance (sample & population), standard deviation (sample & population).
- Exponential average (mean), exponential variance, exponential standard deviation.
- Weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.
Previous Versions
Here you can find the changelog of SQLRollingStats since it was posted on our website on 2015-04-27 03:00:00.
The latest version is 1.0.0.0 and it was updated on 2024-04-22 12:08:48. See below the changes in each version.
SQLRollingStats version 1.0.0.0
Updated At: 2011-05-03
Changes: New release
Related Apps
Here you can find apps that are similar with SQLRollingStats.
We do not host SQLRollingStats on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by the software publisher and passed their terms and conditions to be listed there. We recommend caution when installing it.
The external download link for SQLRollingStats is provided to you by apps112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of apps112.com contact us.
