Input Parameter

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  October 29, 2013 at 1:53 pm

  #278645

  I need the Input Parameter to display monthyear in drop down fashion.

  example : Aug2013 or Feb2011

  How can I achieve this?

  Also , The source table does not have all the years , will we have to use a separate data set for this ?

• lynns

  Say Hey Kid

  Points: 695

  More actions

  October 30, 2013 at 8:28 am

  #1662735

  I would use a separate dataset to generate the data. The following query creates 36 months of entries beginning at 1/1/2011.

  SELECT (CHOOSE(DATEPART(m,dateadd(month,number,'20110101')),'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC'))

  + (CONVERT(nvarchar(4),DATEPART(yyyy,DATEADD(month,number, '20110101'))))

  from master..spt_values

  where type = 'p' AND number < 36