как-то через раз проявляется, наверно просто сервер бывает перегружен

Безымянный 01.07.2008 11:20

SELECT
 concat(convert(MESN,SQL_VARCHAR),
 convert(YEARN,SQL_VARCHAR)) AS mesyear,
 MESN,
 YEARN,
 ROUND(SUM(SUMMA),0) AS SUMMES
FROM
 SUMVIDOP
WHERE
 (vidopl=1 or vidopl=2 or vidopl=3 or vidopl=5 or vidopl=6 or vidopl=7   or vidopl=9 or vidopl=10 or vidopl=11
 or vidopl=12 or vidopl=13 or vidopl=14 or vidopl=15 or vidopl=16 or vidopl=17 or vidopl=18 or vidopl=19 or vidopl=20
 or vidopl=25 or vidopl=27 or vidopl=30 or vidopl=31 or vidopl=32 or vidopl=33 or vidopl=34 or vidopl=35 or vidopl=36
 or vidopl=37 or vidopl=38 or vidopl=39 or vidopl=47 or vidopl=48 or vidopl=50 or vidopl=52 or vidopl=69 or vidopl=87
 or vidopl=96 or vidopl=97 or vidopl=101 or vidopl=103 or vidopl=104 or vidopl=105 or vidopl=106 or vidopl=108 or
 vidopl=109 or vidopl=110 or vidopl=112 or vidopl=113 or vidopl=114 or vidopl=115 or vidopl=116 or vidopl=117 or
 vidopl =118) And 
 ((MESN >= $mes1 and YEARN = $year1) OR (MESN <= $mes2 and YEARN = $year2)) AND TABN = $tabn
GROUP BY MESN, YEARN
ORDER BY YEARN, MESN