Used SQLRollingStats for Windows? Share your experience and help other users.


Key Details of SQLRollingStats

  • Get Microsoft SQL Server windowed rolling statistics function library
  • Last updated on 05/25/11
  • There have been 0 updates within the past 6 months
  • The current version has 0 flags on VirusTotal badge_icon

Developer’s Description

Get Microsoft SQL Server windowed rolling statistics function library.
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). - 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.


Explore More


Full Specifications

GENERAL
Release
Latest update
Version
1.0
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows Server
  • Windows 7
  • Windows 10
  • Windows Vista
  • Windows XP
  • Windows 2003
Additional Requirements
None
POPULARITY
Total Downloads
23
Downloads Last Week
0

Report Software

Program available in other languages


Last Updated


Download.com
Your review for SQLRollingStats