select *  FROM         ZpSvod
where ZpSvod.zpname='201212'

(50718 row(s) affected)

SELECT     ZpSvod.SUMMA, ZpSvod.TABN, ZpSvod.zpname
, dbo.ZpSvod.NO, dbo.ZpSvod.KR 
FROM         ZpSvod
LEFT OUTER   JOIN
(SELECT     NO, TABN, MAX(DAT_POST) AS Expr1, CASE WHEN KR = 9 THEN 1 ELSE 2 END AS workbas, LEFT(FileName,4) as zpname
FROM         TabelSvod
GROUP BY NO, TABN, CASE WHEN KR = 9 THEN 1 ELSE 2 END, FileName
HAVING      (FileName = '20121201')) tab
ON  cast(LEFT(ZpSvod.zpname,4) as int)=cast(tab.zpname as int) AND ZpSvod.TABN = tab.TABN
 and (CASE WHEN zpsvod.KR = '9' THEN 1 ELSE 2 END) = tab.workbas
 where ZpSvod.zpname='201212'

(50793 row(s) affected)

SELECT     ZpSvod.SUMMA, ZpSvod.TABN, ZpSvod.zpname
, dbo.ZpSvod.NO, dbo.ZpSvod.KR
,  tab.TABN
FROM         ZpSvod
LEFT OUTER   JOIN
...
where ZpSvod.zpname='201212'
and tab.TABN is NULL

select * FROM ZpSvod