Post reply

How to preapare Vintage Analysis report in sql

  • August 9, 2019 at 6:46 am

    #3670137

    hi,

    How to preapare Vintage Analysis report in sql.Can someone help me with code.

    Sample dat and Desired output is attached for reference.

    Attachments:
    You must be logged in to view attached files.

  • August 9, 2019 at 3:15 pm

    #3670323

    avdhut.k wrote:

    Can someone help me with code.

    Not likely.  First, most people won't open a spreadsheet on forums.  Second, the spreadsheet contains no formulas so there's no information in it to even make a guess.  Third, you've provided absolutely no information as to what the process is.  Fourth, if you really want help, you need to provide the data in a readily consumable format (see the first link in my signature line below for one method to do that) along with a good explanation of what you are actually trying to do.

    You also need to show that you've at least tried.

    Of course, you've been on these forums to already know all of that.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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