se me fue un parentesis:
Código SQL:
Ver originalSELECT * FROM (
SELECT MOTIVO, ROW_NUMBER() OVER(partition motivo ORDER BY mes) AS rn FROM S_01_OM01_SEG_VTA_APEX_ACUM WHERE ANNO='2015' AND MICOD IN (SELECT micod FROM #temp)
ORDER BY CONVERT(FLOAT,MES) DESC, CONVERT(FLOAT,DIA) DESC
) AS t1 WHERE rn<=4
saludos!