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).
- 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.
SQL Server 2005 or later
Like it? Share with your friends!
Other Windows Software of Developer «TotallySQL»:
Assembly Manager Assembly Manager is a windows application aimed at both SQL CLR developers and SQL DBAs that solves the problems of trying to manage CLR assemblies using just Visual Studio or SSMS.
It allows you to see in a tree-structured view all installed CLR assem
SQLEngineering SQLEngineering extends the T-SQL scripting environment to add direct support for technical, engineering and scientific applications at the database layer.
Performing data analysis from within the database tends to be much faster and more efficient than
SQLMath SQLMath extends the T-SQL scripting environment so you can perform mathematical operations on your data from within the database itself. This tends to be much faster and more efficient than transporting the data across the network to a client application,
SQLDistributions SQLDistributions extends the T-SQL scripting environment to by adding support for modelling and analysing probability distributions directly within the database.
Performing data analysis from within the database tends to be much faster and more efficie
SQLFinancials SQLFinancials extends the T-SQL scripting environment by adding financial analysis functions similar to those found in the MS Excel analysis toolpack, but which can be used directly within the database.
Performing data analysis from within the database
SQLTuples SQLTuples is a FREE product that adds a number of tuple types and constructor functions within the T-SQL scripting environment that can be used anywhere that a compound type is needed.
Tuples of between 2 and 6 elements can be constructed easily using
SQLStatistics 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. This tends to be much faster and more efficient than transporting the data ac
SQLUtilities SQLUtilities extends the T-SQL scripting environment by adding 64 new general-purpose functions for text, date/time and numeric processing that can be used directly within queries and stored procedures at the database layer.
Date and time functions inc
TMS Scripter Studio(Delphi 7) TMS Scripter Studio adds the ultimate flexibility and power into your applications with native Pascal or Basic scripting. It allows modification of the application behaviour without needing to update the full application.End users can add totally new funct
TeeChart for PHP Feature Summary:
100% PHP5 code
Full PHP sourcecode available
Support for PHP5 and above
Chart Components for Delphi for PHP Applications
Direct access to URL addressable Charts
Designtime PHP Form WYSIWYG Chart Control
Add-in Express for Office and VCL With Add-in Express for Office and VCL you can create powerful, fast, and easy deployable plug-ins for all available Microsoft Office versions, including Office 2010, 2007, 2003, 2002 (XP) and Office 2000. Add-in Express is completely based on the Rapid Ap
Accelerator Generator Accelerator Generator is an add-in for Delphi that works seamlessly with Delphi's integrated development environment. It helps you by generating all the accelerator keys you need for your forms, making sure that even the shortest words get an accelerator k
Cory Greeting Cards Script Want to send a funny birthday or Christmas card to your friends, a beautiful card with your kids' photo to your parents, an invitation to a party or dinner, a thank you card to your clients, a get well card to co-workers, a love card to a special someone o
Visio IFilter The Microsoft Visio IFilter is a component used by the Microsoft Windows Indexing Service to build index catalogs that enable users to search for specified text in Microsoft Visio files(.VSD, .VSS, .VST, .VDX, .VSX, .VTX formats). These index catalogs are
Websites Screenshot DLL The Websites Screenshot DLL is a .NET Class Library to render Web site page. It allows you to capture Web site page and create full size screenshot or thumbnail preview in a number of different formats like JPG, GIF, PNG, BMP, and TIF. You can use this dll
Windows CE Platform Builder 2.11 QFE 30 Fixes made in this QFE:Component: NDISDescription: NDIS PCMCIA code was not checking to see whether a net card supported 16-bit I/O adccess, and was always mapping an 8-bit window. This resulted in sub-optimal performance for these cards. This version is t
Aspose.Words for Java Aspose.Words is a Java word processing component to read, write, modify & convert Word documents without using Microsoft Word. It supports all java applications and works with J2SE 1.4.x and higher. Other advanced features include content & formatting mani
Game Cloud Emulator Game Cloud Continental is a game networking solution of a new generation. It extends the capabilities of the known game servers tens and hundreds of times.
Game Cloud Continental helps in two major directions:
- helping small game developers to deliver
Supported Operating Systems:
Windows XP |
Comments on SQLRollingStats:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10