Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ankitnigam
Starting Member
2 Posts |
 Posted - 2010-10-28 : 01:11:00
|
| I am Building a "CAB Booking Application" in that i have done few things:1> Firstly i have created the Cab tour on particular Date.2> Secondly i have plotted its set for particular passenger reservation.3> Payment through PaypalNow i above what i needed is that "Once the Cab is Created it Automatically fill data for 90 Days i.e according to Date n Time.{Suppose this CAB is for 3 Month Service i.e 90 Days and Runs Daily from Today i.e 28 Oct 2010 to 28 Jan 2011} i want to track all the record of particular days in which it is running.for that i am trying to find the most efficient solution to fill the record.or if u can suggest me how to keep track of all CAB from Date Created till the limit of End Date.Note: this end date might be One Year alsoIts very Urgent.Ankit Nigam |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-10-28 : 10:33:26
|
| booking can also happen on weekends? Saturday Sunday? what about holidays?If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Insert querry for 3 Months Tour Data