T-SQL Programming Itzik Ben-Gan in T-SQL Programming T-SQL Fundamentals: Controlling Duplicates When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand... 28 September 2023 20 min read
T-SQL Programming Itzik Ben-Gan in T-SQL Programming T-SQL Gap-Filling: Filling Missing Dates with LAG, IGNORE NULLS, and Range Matching Three T-SQL approaches for filling gaps in a time series with last-known values (LOCF imputation): TOP-based lookup, IGNORE NULLS (SQL... 29 May 2023 19 min read
