I need to create a table (or insert in a table) as follows
- I know the starting date and ending date e.g. 2011.10.12 and 2011.10.16
- I should generate a record for each day between the two dates.
For example the output of the example above would be:
Of course in the real situation the dates can be for example from 2007.01.01 to 2010.10.12 so I can't do this manually.