In some cases we need to generate the data based on a starting date, to an end data (today-getdate()). This process is called data extrapolation based on limited information (starting date).
Here I am trying to achieve the same without storing data in temp./staging tables.
First I am creating a temp. table wih 2 rows and now I need to generate rest of the rows starting from given date to today's date.
Next step is to make use of CTE to generate sequence of rows and finally making use of CROSS JOIN to join the sequence with real data and get the desired output.
Thanks
Mohit Nayyar