Pawan Khowal shows one example of implementing Last Observation Carried Forward in T-SQL:
A very close friend given this to me. In this puzzle you have to fill the price of SKU & Color Id for missing months. Note that SKU & Color Id should be considered as a business unit. So you have to set the previous value available to the missing month. Please check out the sample input and the expected output. In this solution I have not considered any performance considerations.
Included is one solution, though there are others.