Blog Archives

How to backfill data using SQL – populate missing values from historical data

T SQL Date format convert function

Consider scenario where you want to populate missing data from previous date when data was available. In the following example we want to populate price of orders from most recent previous date when price was available. create table #orderinfo (

Tagged with: , ,
Posted in SQL Server, T-SQL Tips