Re: Analytical query help

I created a simple TIMES table and code works great.

Query returns data like this

12/04/2009 ssmit 52
12/02/2009 ssmit 48
11/30/2009 ssmit 45
11/29/2009 ssmit 42

I want the data to be like this

12/04/2009 ssmit 52
12/03/2009 null      0 -- fill the gap with previous value
12/02/2009 ssmit 48
12/01/2009 null
11/30/2009 ssmit 45
11/30/2009 ssmit 45
11/29/2009 ssmit 42