Inserting Previous Non Null Values for missing Dates

by Itachiara   Last Updated May 21, 2018 22:06 PM

I have a table as

Current Table

As it is seen, there is may and july ( 2017-05-01,2017-07-01) not in the table. I want to insert the previous non null ( in this case April's data for may and june's data for July) to also be included in the table . How to accomplish this ?

Desired Table

Thanks, Arvin

Tags : sql-server sql cte

Related Questions

creating index on big table(s)

Updated September 03, 2018 18:06 PM

Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM