T-SQL: Bitwise Arithmetic

Using bits as flags. Recording user settings, often as “categories” represents significant persistence within many applications. Storing all these values… Read more T-SQL: Bitwise Arithmetic

T-SQL: WITH

Performing Recursive Queries. Prior to SQL Server 2005, performing recursive actions on data required the use of temporary tables, cursive,… Read more T-SQL: WITH

T-SQL: Trigger – INSERT AFTER

Initiating actions in response to events. One of the new features provided with SQL Server 2005 enables actions to be… Read more T-SQL: Trigger – INSERT AFTER

Excel: String Split

Splitting a string with multiple delimiters in Excel. Often when using Excel, especially when viewing CSV file exports from other… Read more Excel: String Split

Excel: VLookUp

Creating a list lookup. Many Excel spreadsheets contain data spread across many different worksheets and in collaboratively work environments, worksheets… Read more Excel: VLookUp