Data Aggregation with SQL: Summing Quantity by Date in SQL Server 2008

Retrieving the Maximum Change Date for Multiple IDs Using Different Tables: Two Effective Methods