Function that converts AD UserAccountControl number to details text  Read more...

Returns your date in the format mask you require.  Read more...

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes  Read more...

SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.  Read more...

This function returns all the necessary version information in a table.  Read more...

This function decode HTML string to ASCII format string.  Read more...

After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.  Read more...

This function takes a UNC file as a parameter and return the last modified date  Read more...

This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM' Ex. '200907111405' Convert to '2009-07-11 14:05:00'   Read more...

This function gets a variable and converts to DateTime format string 'YYYYMMDDHHMM' Ex. '07/11/2009 2:05 PM' Convert to '200907111405'  Read more...

The statement is splited into columns according the delimter and it has been captured in the table datatype.  Read more...

This function will return the first, second, third, fourth or last day of a given month.  Read more...

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...

A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.  Read more...

These SQL functions will allow you to convert decimal numbers to words  Read more...

This function will strip out anything that is not a number (0-9)  Read more...