Data extrapolation on the fly

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

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

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

  • FYI this does not work for SQL Server 2000.

  • 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