A generic approach to the problem. I am assuming a Tally Table (dbo.ScSrNo) with sufficient "SrNo" corrosponding to Number of Months counted from 1900-01-01.

Data Table definition: CREATE TABLE test.StockGapFill (...