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
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,
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
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
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
The DSETA Framework The DSETA framework is a complete solution for the conception, development and production of data sharing systems based on a client-server architecture. DSETA represent, for an Architect, the shortest way between his concept of data sharing system to the p
Decode/Encode DLLs For software developers, the Decode/Encode DLLs can be called from any Windows programming language (such as VB, Visual C, Powerbuilder, etc.). It allows you to automatically detect if a given file is UUENCODED, Base64(MIME), XXENCODED, BinHex, user table,
Precision Language Suite Portable Precision Language Suite Portable consists of "Localization source codes" and the "Localization projects editor". The suite allows localization of VCL component properties, text strings and system messages. It uses a text format for localization files - la
BoostSolutions Foundation BoostSolutions Foundation is mainly designed to provide a centralized interface to manage licenses for all BoostSolutions software from within SharePoint Central Administration. It has a built-in ability to display the software version number, or license t
Logicweb Studio Logicweb Studio provides developers with high quality functionality to create professional, scalable and secure Web application rapidly. Developers can focus on programming the essential business logic behind the application rather than the user interface
Mgosoft PCL To Image SDK Mgosoft PCL To Image Converter is a fast, affordable way to batch convert PCL and PXL print files to image formats. It directly convert PCL files to dozens of image formats, such as TIFF, JPEG, PNG, BMP, PCX, GIF, WMF, EMF, TGA and so on, it retains the la
GizmoRBControls This program is dedicated to the distribution of classes, controls and containers for programmers in RealBasic. The program is both an illustration of what these components provides and gives the necessary documentation for their use. The current version o
Matplotlib Matplotlib is a python 2D plotting library. It produces publication quality figures in a variety of hardcopy formats and interactive environments across platforms. Matplotlib can be used in python scripts, the python and ipython shell, web application serv
OCX DTMF Keybord Visual component used to generate a DTMF sound into your sound card. Play directly the sound, no dll needed. Work well with VB, VC++ and Delphi. The Ocx could be registered by the Dos command: regsvr32 DTMFX.ocx.Requirements:Windows 95/98/Me/NT/2000/XP
C= Parallel C/C++ Programming Language Extension C= (pronounced 'See Stripes') is a Parallel C/C++ Programming Language Extension.
It is designed to cover all typical parallel programming paradigms and complement or even substitute existing parallel language extensions and libraries by providing a sing
Supported Operating Systems:
Windows XP |
Comments on :
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