How to Use SQL LEAD and LAG Window Functions to Solve Gaps-and-Islands Problems

Why does my SQL scalar function sometimes throws "Subquery returned more than 1 value. This is not permitted..."?

How to Resolve 'A Network-Related or Instance-Specific Error Occurred' When Upgrading to SQL Server 2019