Post reply

Generate Month's based on previous values

  • July 7, 2015 at 4:05 am

    #398704

    Hi,

    I have a data that with month values ranging from jan 2012 till july 2013 with some values associated with it.

    I want to generate months automatically after july 2013 till december 2013 in sql something like the below one:

    Is there a way in sql to do this?

  • July 7, 2015 at 4:09 am

    #1810647

    karthik82.vk (7/7/2015)

    Hi,

    I have a data that with month values ranging from jan 2012 till july 2013 with some values associated with it.

    I want to generate months automatically after july 2013 till december 2013 in sql.

    Is there a way in sql to do this?

    Left join from a calendar table to your data.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 7, 2015 at 4:47 am

    #1810659

    Hi,

    Thanks for your help.... I got the solution.

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

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