在此select中,我希望获取上个月和本月的值并显示6列: OLDVALUE本身~ OLDVALUE X 28,8% ~ OLDVALUE X 8% ~ CURVALUE本身~ CURVALUE X 28,8%~ CURVALUE X 8% AND MES = CASE WHEN (PROV.MES-1 = 0) THEN 12 EL
WHILE (SELECT TOP 1 FECHA1 FROM #PERIODO) > 0 SET @MES_ANTERIOR = (SELECT TOP 1 FECHA1 FROMFROM #PERIODO A ORDER BY FECHA1 ASC ) B ORDER BY B.FECHA1 DESC)
SET @MES_3 = (SELECT TOP= LEFT(CONVERT(VARCHAR(8),@MES_ANTERIOR,112),8)