What I would like to do is "fill in" the missing dates for 5/30 and 5/31 with the previous balance amounts (this should apply to any dates which are missing). I found this thread which could work for this:
However, I am having trouble getting this to work with the three columns since the date ranges can be different depending on the Entity Key. The only thing I can think of is doing a loop and filtering the data by entity key, creating the temp tables with just the balance and date, and then doing the join, populating this into a temp table, and finally concatenating the next set of data to the end.
Just wondering if there is a more efficient way of doing this? Any help is appreciated.
