Hi, I have very simple problem, I have several tables (each is specific country), which include dates and unique values, but some of them are missing, because of holidays and weekends.
e.g.
Country A Value Value2
1.1. 2011 20 10
3.1. 2011 30 15
4.1. 2011 30 20
Country B Value
1.1. 2011 4
2.1. 2011 3
3.1. 2011 3
Country C etc.


I want to do few queries, which can analyze the structure of missing dates. At first I would like to fill values of missing dates with a value of preceding date to make a smooth graph or fill zero(or other value) to the missing dates to emphasize that the input was missing.
So the Table would look like
Country A Value Value2
1.1. 2011 20 10
2.1. 2011 20 10
3.1. 2011 30 15
4.1. 2011 30 20
or
1.1. 2011 20 20
2.1. 2011 0 0
3.1. 2011 30 30
4.1. 2011 30 30
Secondly I would like to display all the dates without weekends. So it would be clear that dates with zero values are national holidays for particular coutries, I know that holidays are mostly unique and that is the goal what I would like to analyze.
Thank you for advices