Window functions allow you to apply calculations against "sets" or groups of data. These sets are known as windows. Many books classify window functions as an advanced topic in T-SQL. But in fact, once you see some practical examples window...
Archive for August, 2013
Temporary Tables are a handy technique for creating cascading logic. Results from one temporary table can be passed to other temp tables. This can simplify the process for creating complex result sets. Temporary tables are saved to disk, and are...