Updating value from last entered value

[Santysri1976]

I am having a database like
Childid Month Height
1 Jan-2019 12.5
1 Feb-2019 null
1 Mar-2019 null
1 Apr-2019 13.5
2 Jan-2019 10.0
2 Feb-2019 null
2 Mar-2019 10.5

Now I want a query which will update null value in height with last taken month and the result should be like
Childid Month Height
1 Jan-2019 12.5
1 Feb-2019 12.5
1 Mar-2019 12.5
1 Apr-2019 13.5
2 Jan-2019 10.0
2 Feb-2019 10.0
2 Mar-2019 10.5

 

[johnherman]

Update Table M set M.height = (Select top 1 S.height from Table S where S.height not null and M.childid = S.childid order by S.childid S.month descending) where M.height is null;

untested

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity