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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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