New Topic Insert querry for 3 Months Tour Data

  • 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[font="Arial"][/font]

  • ankit.uneedme (10/27/2010)


    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[font="Arial"][/font][/b]

    If it's truly urgent, then you need to help us out a lot more than what you have.

    You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put some test data into those tables that shows your problem will go a long way in getting people to look at your issue and help you out. Please include code for what you have already tried. Don't forget to include what your expected results should be, based on the sample data provided. As a bonus to you, you will get tested code back. For more details on how to get all of this into your post, please look at the first link in my signature.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply