Post reply

Data extrapolation on the fly

  • September 26, 2008 at 7:16 pm

    #198653

    Comments posted to this topic are about the item Data extrapolation on the fly

    Thanks
    Mohit Nayyar
    http://mohitnayyar.blogspot.com/
    "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

  • November 14, 2008 at 6:00 am

    #898504

    I think you lost me here:

    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

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • November 14, 2008 at 8:57 am

    #898679

    I am creating the temp. table to DEMO the functionality. But in real world case you will use the actual table. So not temp. table required for extrapolation.

    Please let me know if there is anything else I can help with.

    Thanks
    Mohit Nayyar
    http://mohitnayyar.blogspot.com/
    "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

  • November 14, 2008 at 11:03 am

    #898767

    FYI this does not work for SQL Server 2000.

  • November 14, 2008 at 11:08 am

    #898771

    Yes, this is very much clear for everyone who understands CTE.

    Thanks
    Mohit Nayyar
    http://mohitnayyar.blogspot.com/
    "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

Viewing 5 posts - 1 through 4 (of 4 total)

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