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.
Free download from Shareware Connection - CLR-based function library for SQL Server that adds 31 windowed / cumulative functions that can be used directly in queries.
SQLFinancials - CLR-based financial functions library for MS SQL Server that adds spreadsheet-like financial analysis capabilities at the database layer
SQLStatistics - CLR-based library of statistical functions for use in SQL Server T-SQL scripts and stored procedures. Includes tests for correlation & significance, descriptive metrics (e.g. weighted average, skewness, kurtosis), extrapolations etc.
Assembly Manager - Graphical overview of CLR assemblies, functions, stored procedures etc. across servers and databases. Drag/drop installation/removal. Generates full change/rollback scripts.
SQLEngineering - CLR-based function library for SQL Server including special Engineering functions, unit conversions, number base conversions and a full complex numbers math library.
SQLUtilities - CLR-based function library for SQL Server that adds a variety of useful text, date/time and numeric processing capabilities including date/time & number sequence generators, random numbers, random dates, regular expressions.
SMS Messaging SDK
Hex to ASCII Converter
OCR Image to Ascii Utility
SMS and Pager Toolkit
Audio Capture ActiveX Control
Virtual Serial Ports Driver XP
ActiveComport Serial Port Toolkit
Java Barcode Reader
SMTP/POP3 Email Engine for C/C++
MediaLooks Video Mixer
Chilkat S/MIME Encryption ActiveX Component
DLL to Lib
C & C++
Components & Libraries
Databases & Networks
Editors, IDEs & Coding Utilities
Help File Tools
Languages - Others
Management & Distribution
Moving Average Sample
Weighted Moving Average
Adaptive Moving Average
Moving Average Filter Imagej
Exponetial Moving Average Excell
SQL: Sum, Average, Max, Min, Count, Detail - This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.
Total Folder Monitor - Total Folder Monitor will watch your folders and execute predefined actions. They include creating file list; pinging; running some application; copying, moving or deleting some file; terminating project or task; packing/unpacking files.
Emsa Bandwidth Monitor - Emsa Bandwidth Monitor is a handy utility which allows monitoring your internet connection speed, total traffic, average download/upload speed,and more. Freeware.
CalcuNote - CalcuNote is an arithmetic calculator, adding machine, and time calculator that documents calculations on multiple tapes which you can edit. It can make and record complex sets of interrelated calculations, print and save tapes.
Advanced Link Tracking Script and Complete Website - USER PANEL FEATURESAccount Management: * Add/Delete Site * Change Password * Get the CodeView Stats: * Select Time Period between 30 and 365 days * Display Total Hits, Total Visitors, Average Visitors Per Day, Total Hits For Last 30 DaysHit Statistic
Shareware Connection periodically updates pricing and software information of 'SQLRollingStats' from company source 'TotallySQL Ltd' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using 'SQLRollingStats' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of SQLRollingStats.
Xara Designer Pro X9 - Design professionals involved in jobs like vector illustration, web design and image editing usually resort to mainstream apps from stables of industry behemoths like Adobe and Corel. While Photoshop and CorelDraw are industry standard versatile ...
Adobe Photoshop Elements - For Adobe product users, especially those into image editing and photography, it is natural to expect a refresh to its popular Elements software lineup near fall season. As per user expectations, the technology giant has unleashed the revamped ...
QuarkXPress 10 - Graphics designers, print media veterans and those into publishing industry need no introduction to QuarkXPress. The powerhouse publishing app, used widely by Mac and Windows users worldwide has served as a viable choice for those looking for an ...
Norton Internet Security - Everybody who uses the internet is currently under threat from catching a huge variety of viruses. These include trojan horses, malware and spyware. Which can include keyloggers, rats or even spycams which record everything you do on the ...
PrimoPDF - PrimoPDF is one of the programs that can solve a lot of issues with PDF files. It gives you the possibility to turn any printable file into a PDF file. The respective PDF files can be read, managed and edited with the application, but also ...
Stunt Dirt Bike 2 - Like most other motocycle online flash games, Stunt dirt bike 2 consists of the player driving through the course tackling obstacles and jumps until they reach the end of the level. It has a good soundtrack, and good artwork for graphics. So I ...
Fanged Fun - For anyone who has played any game from the super stacker series will known that for some reason, shape puzzle and physic games can be somewhat, very fun. However in that series you usually found yourself building objects with the shapes, or just ...
Catapult Madness - Catapult madness is a flash game in a popular genre – where you fling things as far as they can go collecting money whilst you do it. You know, games such as Burrito Bison, shopping cart hero or flight? This genre as I said, has become ...
MaxiVista - Multi Monitor Software - Maxivista multi monitor has a clever concept of turning a spare laptop, or one you use regularly, on your network into another monitor for your desktop computer. This is, however, not limited to just your laptop but can be used for tablets as ...
Plagiarism Finder - Copyright infringement is a huge occurrence at this current time. Why? Because you can simply type something into google, find a very well written document or article and simply copy and paste it as there own. This is happening so often now that ...