Using Case Expressions to Simplify Aggregate Functions in SQL

Understanding Left Outer Joins: How to Fix a Join That Isn't Returning Expected Results

Understanding How to Handle Multiple Values in SQL Server Reporting Services (SSRS) Parameters Without Forcing User Selection