Data extrapolation on the fly

  • Mohit Nayyar

    Ten Centuries

    Points: 1008

    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"

  • jcrawf02

    SSC-Insane

    Points: 24198

    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."

  • Mohit Nayyar

    Ten Centuries

    Points: 1008

    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"

  • RC Davis

    SSC Rookie

    Points: 25

    FYI this does not work for SQL Server 2000.

  • Mohit Nayyar

    Ten Centuries

    Points: 1008

    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 5 (of 5 total)

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