List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:March 25 2010 4:50pm
Subject:Populating dataset
View as plain text  
Hi,

We have a table which contains the following sample of information

2010-03-20
2010-03-21
2010-03-22
2010-03-23
2010-03-26
2010-03-27
2010-03-28
2010-03-30

As you can see, the dates listed are not constant e.g missing 2010-03-29 as
a example.  For our query like SELECT check_in_date FROM bookings how would
I know to automatically insert a missing date like 2010-03-29 between the
date range I search ?

Thanks,
Neil

Thread
Populating datasetTompkins Neil25 Mar
  • Re: Populating datasetJohnny Withers25 Mar
  • Re: Populating datasetMartijn Tonies26 Mar
  • Re: Populating datasetPeter Brawley26 Mar