Calculating Running Totals Based on Changes in Indicator Columns Using Group Row Numbers and Window Functions

Generate Alphabetical Sequence Code for Specific IDs in SQL Server