|
|
Development /
Components & Libraries / SQLRollingStats 1.0.0.0 Free Download
|
| "CLR-based function library for SQL Server that adds 31 windowed / cumulative functions that can be..."
Quick Download SQLRollingStats 1.0.0.0
|
|
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.
|
|
Related Search For SQLRollingStats
|
| Download Sites : | | www.totallysql.com |
|
SQLRollingStats |
Version: | 1.0.0.0 |
File Size: | 522 KB |
Last updated: | 2011-05-03 |
License: | Free Trial $199 |
OS: | WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64,WinServer |
Author: | TotallySQL Ltd
|
| Related Software - SQLStatistics 1.0.0.0
SQLStatistics extends the T-SQL scripting environment so you can carry out statistical tests, calculate metrics and perform analyses on your data from within the database itself....
- Stats Master 3.0
The package offers statistical routines forDelphi/BCB 6,7,2006,2007 developers
Statement Do-download.com do not supply any crack, patches,torrent, password, serial numbers, registration codes, key generators, cd key, hacks or keygen for the software,and please consult directly with program authors (TotallySQL Ltd) if you have any problem with the software. |
|