SQLRollingStats

Rating: No reviews yet
Downloads: 735
Released: Apr 28, 2013
Updated: Apr 28, 2013 by cgsouthey
Dev status: Stable Help Icon

Recommended Download

Documentation Documentation in HTML format (zipped)
documentation, 432K, uploaded Apr 28, 2013 - 71 downloads

Other Available Downloads

Documentation Documentation in PDF format
documentation, 514K, uploaded Apr 28, 2013 - 304 downloads
Application SQLRollingStats as install script
application, 174K, uploaded Apr 28, 2013 - 167 downloads
Application SQLRollingStats as Assembly Manager library
application, 99K, uploaded Apr 28, 2013 - 96 downloads
Application SQLRollingStats as raw dll
application, 61K, uploaded Apr 28, 2013 - 97 downloads

Release Notes

SQLRollingStats is a unique solution for SQL Server that extends and enhances your T-SQL programming environment by adding 31 powerful new statistical window functions - allowing the computation of results per row that depend on values in other rows. All functions are capable of taking into account all rows so far processed, or just the last n rows where n is the specified window size. Functions include:
  • Sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous.
  • Average (mean), variance (sample & population), standard deviation (sample & population).
  • Geometric mean, harmonic mean, quadratic mean.
  • Median, quartile, inter-quartile range, tri-mean, percentile, percentile rank.
  • Exponential average (mean), exponential variance, exponential standard deviation.
  • Weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.

Reviews for this release

No reviews yet for this release.