Fill and Replace ValuesThere are times when you need to clean your dataset. Suppose you had a simple table of employees […] December 27, 2022 in Excel tagged power / values / replace / query / gaps / fill / Power Query Transform by Mike
SQL Server GapsWhat are gaps? Gaps and islands are classic challenges in T-SQL that involves a sequence of values. The […] April 1, 2018 in SQL Server tagged sequence / gap / gaps / lead by Mike