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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Insert querry for 3 Months Tour Data

Author  Topic 

ankitnigam
Starting Member

2 Posts

Posted - 2010-10-28 : 01:13:20
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 Paypal

Now in 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 also

Its very Urgent.

Ankit Nigam


Ankit Nigam

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-03 : 06:55:38
You need to post table structure with some sample data

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -