Join or Sign In

Sign in to add and modify your software

Sign in with Facebook Sign in with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Agreement.

SQLRollingStats

By TotallySQL Free to try

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

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.

Full Specifications

What's new in version 1.0

General

Date Added May 25, 2011
Version 1.0

Operating Systems

Additional Requirements None

Popularity

Total Downloads 23
Downloads Last Week 0
Report Software

Related Software

Access 2007 Download: Access Runtime

Free
Access 2007 Download: Access Runtime

Visual FoxPro 6.0 Setup Wizard

Free
Visual FoxPro 6.0 Setup Wizard

Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)

Free
Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)

Microsoft Visual C++ 2005 Redistributable Package (x86)

Free
Microsoft Visual C++ 2005 Redistributable Package (x86)

Best VPN Services for 2021

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan