with months as ( select distinct purchasingMonth from tbl_DW_DistributorAnalyzer#_tableSuffix# with (nolock) where purchasingMonth <= getDate() ) select format( purchasingMonth, 'MM/dd/yyyy' ) purchasingMonth, format( purchasingMonth, 'MMMM yyyy' ) as purchasingMonthDisplay, purchasingMonth as purchasingMonthRaw from months order by purchasingMonthRaw desc for json auto