title: Get value for each date if not exist then take previous last updated value
body: <p>I have table which have Column EmployeeID, AccountID,updated date. Each row have Data for Account if it changes on date.
  If no change then there is no record for that AccountID on that date. Example</p>
  
  <pre><code>EmployeeID  AccountID      UpdatedDate
  1775    1   2010-12-04 00:00:00.000
  1775    1   2010-08-13 23:59:59.000
  1775    1   2010-08-13 00:00:00.000
  1775    2   2010-12-04 00:00:00.000
  1775    3   2010-12-04 00:00:00.000
  1775    4   2010-12-04 00:00:00.000
  1775    5   2010-12-04 00:00:00.000
  1775    6   2010-12-04 00:00:00.000
  1775    7   2010-12-04 00:00:00.000
  1775    7   2010-06-29 23:59:59.000
  </code></pre>
  
  <p>I have to get value of each account for each person  on each day .  if there is no value on current day then it should take last update value from previous day based on Max update date value.  and show the result like</p>
  
  <pre><code>EmployeeID,Date, Values of each account.
  1775;20120307;45;0;0;0;0;0;0;0;0;0;0;504;0;0;25.0;0.0;0.0;0.0;0.0;0.0;0.0;100;;;;;
  </code></pre>
  
  <p>Can any one help me?</p>