Conditional Calculations in SQL: Using Case Statements to Create New Fields Based on Results of Another Field

SQL Query for Calculating Daily, Monthly, Yearly, and Group Totals from an Existing Table

How to Perform SQL Insert/Update from Another Table Based on a Condition Using the MERGE Statement