SQLRollingStats
by TotallySQL - Product Type: Component / .NET Class / 100% Managed Code
Compute running totals, moving averages, and many other statistics that need relative row references, within T-SQL queries. SQLRollingStats is a solution for SQL Server that extends and enhances your T-SQL programming environment by adding 30+ 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.
Our regular prices are shown below. Please logon to see your discounted prices.
SQLRollingStats - CAL (Client Access License) V1.0
| Add to Cart | $ 146.02 | 1 CAL License | Download (438 KB) | |
| Add to Cart | $ 489.02 | 5 CAL License | Download (438 KB) | |
| Add to Cart | $ 783.02 | 10 CAL License | Download (438 KB) | |
| Add to Cart | $ 1,469.02 | 25 CAL License | Download (438 KB) | |
| Add to Cart | $ 2,449.02 | 50 CAL License | Download (438 KB) |
SQLRollingStats - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance
| Add to Cart | $ 175.22 | 1 CAL License | Download (438 KB) | |
| Add to Cart | $ 583.88 | 5 CAL License | Download (438 KB) | |
| Add to Cart | $ 939.62 | 10 CAL License | Download (438 KB) | |
| Add to Cart | $ 1,762.82 | 25 CAL License | Download (438 KB) | |
| Add to Cart | $ 2,938.82 | 50 CAL License | Download (438 KB) |
SQLRollingStats - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance
| Add to Cart | $ 204.43 | 1 CAL License | Download (438 KB) | |
| Add to Cart | $ 684.63 | 5 CAL License | Download (438 KB) | |
| Add to Cart | $ 1,096.23 | 10 CAL License | Download (438 KB) | |
| Add to Cart | $ 2,056.63 | 25 CAL License | Download (438 KB) | |
| Add to Cart | $ 3,428.63 | 50 CAL License | Download (438 KB) |
SQLRollingStats - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance
| Add to Cart | $ 233.63 | 1 CAL License | Download (438 KB) | |
| Add to Cart | $ 782.82 | 5 CAL License | Download (438 KB) | |
| Add to Cart | $ 1,252.83 | 10 CAL License | Download (438 KB) | |
| Add to Cart | $ 2,350.43 | 25 CAL License | Download (438 KB) | |
| Add to Cart | $ 3,918.43 | 50 CAL License | Download (438 KB) |
SQLRollingStats CAL (Client Access License) - 1 Year Support & Maintenance Renewal
| Add to Cart | $ 29.20 | 1 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 97.80 | 5 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 156.60 | 10 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 293.80 | 25 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 489.80 | 50 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
SQLRollingStats CAL (Client Access License) - 3 Year Support & Maintenance Renewal
| Add to Cart | $ 58.41 | 1 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 195.61 | 5 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 313.21 | 10 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 587.61 | 25 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 979.61 | 50 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
SQLRollingStats CAL (Client Access License) - 5 Year Support & Maintenance Renewal
| Add to Cart | $ 87.61 | 1 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 293.41 | 5 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 469.81 | 10 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 881.41 | 25 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 1,469.41 | 50 CAL Support & Maintenance Renewal License | Verify | Download (438 KB) |
SQLRollingStats - CPU License V1.0
| Add to Cart | $ 2,449.02 | 1 CPU License | Download (438 KB) | |
| Add to Cart | $ 3,919.02 | 2 CPU License | Download (438 KB) | |
| Add to Cart | $ 5,879.02 | 4 CPU License | Download (438 KB) | |
| Add to Cart | $ 9,795.10 | 8 CPU License | Download (438 KB) | |
| Add to Cart | $ 15,674.12 | Unlimited CPU License | Download (438 KB) |
SQLRollingStats - CPU License V1.0 with - 1 Year Support & Maintenance
| Add to Cart | $ 2,938.82 | 1 CPU License | Download (438 KB) | |
| Add to Cart | $ 4,702.82 | 2 CPU License | Download (438 KB) | |
| Add to Cart | $ 7,054.82 | 4 CPU License | Download (438 KB) | |
| Add to Cart | $ 11,754.12 | 8 CPU License | Download (438 KB) | |
| Add to Cart | $ 18,808.94 | Unlimited CPU License | Download (438 KB) |
SQLRollingStats - CPU License V1.0 with - 3 Year Support & Maintenance
| Add to Cart | $ 3,428.63 | 1 CPU License | Download (438 KB) | |
| Add to Cart | $ 5,486.63 | 2 CPU License | Download (438 KB) | |
| Add to Cart | $ 8,230.63 | 4 CPU License | Download (438 KB) | |
| Add to Cart | $ 13,713.14 | 8 CPU License | Download (438 KB) | |
| Add to Cart | $ 21,943.77 | Unlimited CPU License | Download (438 KB) |
SQLRollingStats - CPU License V1.0 with - 5 Year Support & Maintenance
| Add to Cart | $ 3,918.43 | 1 CPU License | Download (438 KB) | |
| Add to Cart | $ 6,270.43 | 2 CPU License | Download (438 KB) | |
| Add to Cart | $ 9,406.43 | 4 CPU License | Download (438 KB) | |
| Add to Cart | $ 15,672.16 | 8 CPU License | Download (438 KB) | |
| Add to Cart | $ 25,078.59 | Unlimited CPU License | Download (438 KB) |
SQLRollingStats CPU License - 1 Year Support & Maintenance Renewal
| Add to Cart | $ 489.80 | 1 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 783.80 | 2 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 1,175.80 | 4 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 1,959.02 | 8 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 3,134.82 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
SQLRollingStats CPU License - 3 Year Support & Maintenance Renewal
| Add to Cart | $ 979.61 | 1 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 1,567.61 | 2 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 2,351.61 | 4 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 3,918.04 | 8 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 6,269.65 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
SQLRollingStats CPU License - 5 Year Support & Maintenance Renewal
| Add to Cart | $ 1,469.41 | 1 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 2,351.41 | 2 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 3,527.41 | 4 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 5,877.06 | 8 CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
| Add to Cart | $ 9,404.47 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (438 KB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
;)
Easy to Use
All SQLRollingStats functions are implemented as types: you need only declare a variable of the appropriate type, assign it a starting value (usually '0') and then call its Result() method in your queries using the syntax @variable.Result(), specifying the input values and a row-number (since almost all forms of rolling statistics are only valid when processed in a given order). T-SQL's built-in ROW_NUMBER() function will usually suffice for the purpose - see the examples given in the Product Documentation for more details.
Support for Tiling
Just as the built-in T-SQL ranking functions such as ROW_NUMBER() support tiling (the ability to group results into distinct blocks and re-start the calculation from scratch at the start of each block) using the PARTITION BY clause, so do the SQLRollingStats functions - so you can in a single query calculate rolling statistics across a number of different domains.
Outstanding Performance and Numerical Accuracy
The algorithms behind the SQLRollingStats functions use industry-proven, best-in-class techniques devised by some of the world's leading numerical computing experts to maximise performance and accuracy even for fairly extreme input values. Careful heuristics and edge-case checks through the code ensure that problems caused by the limitations of floating-point arithmetic on digital computers (such as cancellation errors) are kept to an absolute mininum, and a broad range of special-purpose, high-performance numerical computing approaches are used in place of the slow, expensive computations that would result from 'naive' implementations of the underlying mathematics.
SQLRollingStats Features
- 30+ scalar functions that return results based on data from current row and prior rows in the same query.All functions support a rolling window that discards older values, or can be cumulative (no window)
- All functions support tiling (accumulation of data restarts when input row number restarts from 1)
- All functions provide checking & enforcement of row-processing order using row number inputs
- Sum and product
- Maximum, minimum, range and mid-range
- First (for a window size of n will return input from n rows ago) and Previous (value from prior row)
- Average (mean), sample & population variance, sample & population standard deviation
- Geometric mean, harmonic mean, quadratic mean
- Weighted average, sample & population variance, sample & population standard deviations.
- Exponentially weighted average, variance and standard deviations
- Weighted power mean (generalized mean)
- Median, quartile, inter-quartile range, tri-mean
- Percentile & percentile rank
Quick Links
Publisher
- TotallySQL (9)
Primary Category
- Maths and Stats (33)
Related Products
Related Categories
- SQL (48)