select top 1 convert( int, forecast_year ) claimYear, convert( int, forecast_month ) claimMonth from tbl_MFR_TPF_Detail#_tpfSuffix# where tpartnerId in ( and tpartnerType = 'CDR' and mfr_id = and 'MFR' = and forecast_status = 'C' order by claimYear desc, claimMonth desc select top 1 convert( int, forecast_year ) claimYear, convert( int, forecast_month ) claimMonth from tbl_MFR_TPF_Detail#_tpfSuffix# where tpartnerId = and tpartnerType = 'CDR' and mfr_id = and 'MFR' = and forecast_status = 'C' order by claimYear desc, claimMonth desc select partnername as description, forecast_qty, forecast_amt from qmd_thisYearSales order by forecast_qty desc select sku + ' ' + skudesc as description, forecast_qty, forecast_amt from qmd_thisYearSales order by forecast_qty desc #queryToJSON(qmd_thisYearSales,"FORECAST_AMT,FORECAST_QTY")#