The Query Answers with SQL Server Series

http://www.sqlservercentral.com/articles/Query+Answers+with+SQL+Server/174515/


 * Creating Compound Interest Calculations in SQL
 * Generating Completely Random Sample Output from a Dataset * Generating Completely Random Sample Output from a Dataset
 * Segment Data into Deciles
 * Display Median Values
 * Using a Derived Table to Compare Data with Values from a Previous Year
 * Using a CTE as a Tally Table
 * Aggregate Data for the Last Day of the Month
 * Count the Number of Weekend Days between Two Dates
 * Displaying Hierarchical Data
 * Creating Subtotals and Totals in Aggregated Queries