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»:
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
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
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
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
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,
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
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
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
ZBit Zip-Unzip Component Lite Very light component for zipping and unzipping files from your code. Only provides basic functionality but is very fast and small (only 16Kb). This COM component's two main functions are String UnzipFile(String filename,String outputDir) and String ZipFile
Virtual Drive SDK Virtual Drive SDK allows you to create and manage virtual disks that appear in Windows as regular disks. Virtual disk can be located anywhere: on hard disk, network, random access memory, database etc. Virtual Drive SDK makes possible to implement read/wri
ASTRO GameEngine about
ASTRO is a platform for Windows that has the ability to create 2D games with physical collisions, animations, among others, was developed exclusively for Windows, in the future this rule can be broken, Astro has everything s what needed to developin
SecureBridge Professional SecureBridge represents clients and servers for SSH, SFTP and SSL protocols as a network security solution. It can protect any TCP network traffic using SSH or SSL secure transport layer protocols to provide authentication for client. It is a solution for
ComTL ComTL is an ActiveX component designed to make system integration in minutes. The component allows you to transfer data directly from the source application to the target application without the need to send it to the server or save it in the shared databa
CyaSSL CyaSSL embedded SSL library is a lightweight SSL library written in ANSI C and targeted for embedded and RTOS environments primarily because of its small size, speed, and feature set. It is commonly used in standard operating environments as well because
Chart Plotter 2004 Chart Plotter 2004 is a real-time data plotter capable of plotting/graphing up to 50 measures in a variety of visually appealing styles. Chart Plotter 2004 is a .Net Control, ready to be embedded and used in any .Net project, in any .Net language, includin
XPButton Add appealing visual styles to your applications in all Windows versions with this very quick and powerful button. All new default styles (Windows XP, Office 2003, Visual Studio 2005, 3D standard, Flat, Explorer) and themes are supported (blue, olive, silv
PDF417 Encoder SDK/LIB PDF417 is a multi-row, variable-length symbology with high data capacity and error-correction capability. PDF-417 is a two-dimensional barcode which can store up to about 1,800 printable ASCII characters or 1,100 binary characters per symbol. The symbol is
Windows Explorer Shell Context Menu Pro Windows Explorer Shell Context Menu Component (C#, VB.NET, .NET) - is all you need to add items to Windows explorer shell context menu. This software development component is designed for C#, VB.NET, .NET framework and supports all modern software developm
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