Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.872.793 Times

SQLRollingStats 1.0.0.0

  Date Added: May 23, 2011  |  Visits: 425
5 Stars5 Stars5 Stars5 Stars5 Stars

SQLRollingStats

Report Broken Link
Printer Friendly Version
Order Now

Product Homepage
Download (71 downloads)



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.

Requirements: No special requirements
Release Date: May 03, 2011
Platforms: Windows XP , WinVista,WinVista x64,Win7 x32,Win7 x64,WinServer
Keyword: Sql Moving Average Sql Rolling Average Sql Running Total
Version 1.0.0.0 Changes: New release
Users rating: 0/10

License: Shareware Cost: $199.00 USD Size: 522 KB
USER REVIEWS
More Reviews or Write Review


SQLROLLINGSTATS RELATED
File Cataloguers  -  SQL File Recovery 3.0
SQL file Recovery sort out the problems occurred in SQL Server 2000, 2005 & 2008 due to virus attacks, low disk space, trying to access or copy the mdf file while SQL database is running, defects in storage media etc? SQL files Recovery recognizes...
1.6 MB  
Database Tools  -  DBConvert for MS SQL & MySQL 2.1.0
DBConvert for MS SQL & MySQL is a database migration tool for data conversion from MS SQL database to MySQL server and MySQL db to Microsoft SQL. You can convert SQL data to MySQL or MySQL to MS SQL databases simply by configuring several...
12.51 MB  
Database Tools  -  SQL Defrag Manager 3.0.808.1
SQL defrag manager is the only SQL Server defragmentation solution in the industry that automates the time-consuming process of pinpointing fragmentation "hot spots" and takes action to defragment indexes automatically or on demand. Get SQL...
 
Security Tools  -  Daossoft SQL Password Recovery 3.0.0.1
Daossoft SQL Password Recovery is a handy SQL Server password recovery tool to reset SA password or other user passwords for Microsoft SQL Server 2000,2005 and 2008 database. Unlock password-protected databases master.mdf file instantly! No need...
1.57 MB  
Automotive Information Databases  -  SQL MDF Recovery Free 1.0
Please take a closer look at the efficiency of SQL mdf recovery application by evaluating SQL MDF Recovery Free on your computer, it should not take a lot of time. Thanks to the friendly interface of database recovery program you may start the...
1.91 MB  
Book Collection Managers  -  Access SQL Server Database 6.0
Are you looking for advance SQL recovery tool which allows to access database from corrupt SQL Server? Then you have a great option in a form of SQL Server database access tool which enable to access SQL Server database & guides you to know how to...
3.31 MB  
Business  -  SQL Pretty Printer Add-In for SQL Server Management Studio 3.0.6
SQL Pretty Printer Add-In for SQL Server Management is a plugin to beautify sql code inside SQL Server Management Studio. Features * Format SQL inside SQL Server Management Studio with just one mouse click. * Convert SQL to C#, VB and vice versa...
2.49 MB  
Backup Utilities  -  Sql Backup Free 1.0.1
Sql Backup Free: * Runs Full SQL Server Database Backups on schedule * Compresses (zips) the backups * Sends backups to FTP, local, network folder or HDD drive * Sends an e-mail confirmation on job's success or failure...
643 KB  
Database Tools  -  Easysoft ODBC-SQL Server Driver 1.0
Easysoft ODBC-SQL Server Driver provides ODBC access to SQL Server for ODBC-enabled applications running on Linux and major Unix platforms. Easysoft ODBC-SQL Server Driver supports SQL Server 7, SQL Server 2000, and SQL Server 2005, and is fully...
5.4 MB  
ActiveX Components  -  dbForge SQL Azure Backup 1.0
dbForge SQL Azure Backup is an easy GUI tool for creating backup copies of SQL Azure database to local drive, SQL Server, or Azure Blob Storage for development or archive purposes. The tool enables easy creation of backups as a set of T-SQL...
4.56 MB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  Small Business Manufacturing 2.01.01
The application allows you to easily keep track of the production of commodities, as well as to perform their inventory control. You can specify the components of an article and its production costs. When creating an article, the required...
41.96 MB  
Programming  -  Visitor Management 2.01.01
This program can be used by every organization to register visitors recording. Our software makes it easier to keep track of when and who gets a visit. The program has a special visit log that can be easily used for recording who comes, who has a...
41.96 MB  
Programming  -  Accounting of Books, CDs and other Collections 2.01.01
The program offers you an easy way to manage your books, CDs and other objects. Your articles can be individually aligned to a category and subcategory. There are already pre-defined categories by default, and it is also possible to add your own...
41.96 MB  
Programming  -  Patient Management 2.01.01
The main function of the software is to register all existing patient records and to keep the corresponding register of patients' admissions. It can be used in any hospital admission units which provide registration of their clients. The register...
41.96 MB  
Programming  -  Collection of C++ Examples 1.5
Collection of C++ examples and applications with focus on Windows and Win32 development. Source code is available for use with Visual Studio® 2010 and Visual Studio® 2013 version. This collection covers the...
842.69 KB  
Libraries  -  Mgosoft Image To PDF SDK 8.6.2
Mgosoft Image To PDF Converter is a quick, fast, simple and easy-to-use PDF tool that is designed to batch convert image files into PDF document.It supports quick conversion of batch most of popular image formats, e.g., TIF, TIFF, JPG, JPEG, GIF,...
1.85 MB  
Libraries  -  Mgosoft JPEG To PDF SDK 8.6.2
Mgosoft JPEG To PDF Converter is a quick, fast, simple and easy-to-use PDF tool that is designed to batch convert JPEG files into PDF document.It supports quick conversion of batch JPEG, JPEG2000 files into PDF documents consist of entire...
1.71 MB  
Libraries  -  Mgosoft TIFF To PDF SDK 8.6.2
Mgosoft TIFF To PDF Converter is a quick, fast, simple and easy-to-use PDF tool that is designed to batch convert TIFF files into PDF document.It supports quick conversion of batch TIFF files into PDF documents consist of entire graphics, text and...
1.82 MB  
Libraries  -  GeoDLL 17.28
GeoDLL supports the development of geodetic software on various platforms by providing geodetic functions. GeoDLL contains precise calculations on the themes 2D and 3D coordinate transformation, geodetic datum shift and reference system...
4.41 MB  
Libraries  -  ByteScout PDF Extractor SDK 8.6.0.2911
PDF Extractor SDK for Windows software developers: PDF to Text, PDF to XML, Images from PDF, Read PDF information, PDF to CSV for Excel. Bytescout PDF Extractor SDK allows to convert PDF to text, PDF to XML, PDF to CSV, extract images from PDF,...
595 KB