Workaround for Negative Lengths Using the RIGHT Function in SQL Server 2014

Filtering Rows with Max Effective Date Using Conditional Aggregation in SQL