Fill in Missing Dates, add Default number
===

Assume we have the Date table below, also assume today is the 13th January, 2012:

    DateKey    | AvailabilityPerc  
    -----------------------------
    2012-01-01 | 79  
    2012-01-02 | 80  
    2012-01-03 | 85  
    2012-01-07 | 75  
    2012-01-09 | 90  

The script should do two things:  
1. Fill in the missing dates from the 1st January 2012, up to three days ago, i.e. 10th of January, 2012 (current date minus three days).  
2. For only the new rown, fill in the AvailabilityPerc column with a default figure, say, 100. 

The resulting table should look like this:

    DateKey    |  AvailabilityPerc
    -------------------------------
    2012-01-01 | 79 
    2012-01-02 | 80  
    2012-01-03 | 85  
    2012-01-04 | 100  
    2012-01-05 | 100  
    2012-01-06 | 100  
    2012-01-07 | 75  
    2012-01-08 | 100  
    2012-01-09 | 90  
    2012-01-10 | 100  

Really appreciate any assistance on this.
