SQLUtilities extends and enhances your T-SQL programming environment by adding:

• 21 date and time related functions, including a table-valued date and time sequence generator (allowing you to generate any required set of incremental dates or times of any size on the fly without having to create and maintain lookup tables); random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion.
• 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions.
• 3 very useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function.
• 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.

Beyond Excel

Some of the functions in SQLUtilities are similar in name and function to the date and string processing functions found in Microsoft Excel and similar packages - although generally with significantly expanded functionality and range. There are also many others that are over and above what can be found in Excel. Combined with the innate power and ability of SQL Server to rapidly crunch through huge volumes of data - this gives you a data processing capability that completely blows away anything you could do with spreadsheets.

Easy to Use

All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions, aggregate functions, user-defined types, stored procedures) , keeping the syntax clean and making them as fast and easy to use as the built-in native functions such as LTRIM and DATEADD.