- Audio & Multimedia
- Business
- Communications
- Desktop
- Development
- Education
- Games
- Graphics
- Home & Hobby
- Network & Internet
- Screen Savers
- Security & Privacy
- Servers
- System Utilities
- Web Development
- AnyMP4 DVD Ripper for Mac
- FoneLab Data Retriever
- Recupero File Cancellati
- AnyRec Video Repair
- Aiseesoft Mac FoneLab
- SSuite NetSurfer E-Gamer x64
- USB Disk Undelete
- Verwijderde Bestanden...
- Business Purchase Order
- Secure Eraser
- Atlantis Word Processor
- FrontSketch
- Apeaksoft DVD Creator for Mac
- UltraFileSearch Std
- Pen Drive Recovery Free
- ADRC Data Recovery Tools
- avast! Antivirus
- Revo Uninstaller
- Java Runtime Environment
- AVG Anti-Virus Free Edition
- GOM Media Player
- RegSeeker
- IrfanView
- CPU-Z
- Malwarebytes Anti-Malware
- Spybot Search & Destroy
- Skype
- µTorrent
-
2Printer 5.5
Enables you to print any type documents or files in bath mode one after another specifying the paper size and without any...
-
Vivaldi for MacOS 6.6
No ad browser and uses minimum memory, takes very less time to load, some unique features added like notes containing...
-
Win PDF Editor 3.6.3
Editing PDF documents was like nightmare for me but when I am suggested by one of colleagues I tried this and found that...
-
Serial to Ethernet Connector 9.0
It can successfully turn your computer to a terminal server so that any device connected to the com port will be...
-
ShutUp10 1.4.1388
This software will let you take the full control over your windows 10 and decide which program to start automatically or...
-
TeraCopy 3.26
Copies files seamlessly from source to target location, also detects errors while transferring and rectifies it.
-
Ulysses for Windows 2.7.11
Writing application with most of useful features that a standard word processor may offer like markdown, emerging to...
-
InjuredPixels 4.0
It will repair the damaged pixels of the display unit so that it can still be usable for some more days instead of buying...
-
DrvInfo 1.2.0.2016.0
The software will show you the details of a drive as soon as it is inserted into the port whether it is a floppy, flash...
-
Unreal Commander 3.57
Can see the files in windows. You may copy, cut and paste right from there or upload to server directly.
Development / Components & Libraries / SQLRollingStats 1.0.0.0
SQLRollingStats 1.0.0.0
Advertisement
Advertisement
SQLRollingStats 1.0.0.0 Description
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.
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.
OS: Windows 7, Win7 x32, Win7 x64, WinServer, WinXP
System Requirements: SQL Server 2005 or later
Tags: SQL Running Total - SQL Rolling Average - SQL Moving Average
User Reviews of SQLRollingStats
-
Assembly Manager 1.0.1.0 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... Download
-
SQLMath 1.0.0.0 SQLMath extends the T-SQL scripting environment so you can perform mathematical operations on your data from within the database itself... Download
-
SQLFinancials 1.0.0.0 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... Download
-
SQLEngineering 1.0.0.0 SQLEngineering extends the T-SQL scripting environment to add direct support for technical, engineering and scientific applications at the database layer... Download
-
SQLUtilities 1.0.0.0 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... Download