IF exists(	
select K1.keyRKD --*, K1.OKD, K2.OKD, K1.OND, K2.OND, K1.PSum, K2.PSum , K1.RSum, K2.RSum
            FROM Kassa_RKD_E K1 
            INNER JOIN Kassa_RKD_View_E2_tbl_tmp K2 ON K1.dat = K2.dat
		            AND K1.keyOH=K2.keyOH AND K1.kodF=K2.kodF AND K1.KartAcc=K2.KartAcc AND K1.KartNom=K2.KartNom AND K1.keyCA=K2.keyCA
            WHERE ROUND(K1.OKD-K2.OKD,2)<>0 
            OR
	            ROUND(K1.OND-K2.OND,2)<>0 OR
	            ROUND(K1.PSum-K2.PSum,2)<>0 OR
	            ROUND(K1.RSum-K2.RSum,2)<>0 
	            
	            ) print '1'

select K1.*, K1.OKD, K2.OKD, K1.OND, K2.OND, K1.PSum, K2.PSum , K1.RSum, K2.RSum
            FROM Kassa_RKD_E K1 
            INNER JOIN Kassa_RKD_View_E2_tbl_tmp K2 ON K1.dat = K2.dat
		            AND K1.keyOH=K2.keyOH AND K1.kodF=K2.kodF AND K1.KartAcc=K2.KartAcc AND K1.KartNom=K2.KartNom AND K1.keyCA=K2.keyCA
            WHERE ROUND(K1.OKD-K2.OKD,2)<>0 
            OR
	            ROUND(K1.OND-K2.OND,2)<>0 OR
	            ROUND(K1.PSum-K2.PSum,2)<>0 OR
	            ROUND(K1.RSum-K2.RSum,2)<>0 

cкачать

IF exists(	
 select
  *
 from
  (
   select
    row_number() over (order by (select 1)) 
            FROM Kassa_RKD_E K1 
            INNER JOIN Kassa_RKD_View_E2_tbl_tmp K2 ON K1.dat = K2.dat
		            AND K1.keyOH=K2.keyOH AND K1.kodF=K2.kodF AND K1.KartAcc=K2.KartAcc AND K1.KartNom=K2.KartNom AND K1.keyCA=K2.keyCA
            WHERE ROUND(K1.OKD-K2.OKD,2)<>0 
            OR
	            ROUND(K1.OND-K2.OND,2)<>0 OR
	            ROUND(K1.PSum-K2.PSum,2)<>0 OR
	            ROUND(K1.RSum-K2.RSum,2)<>0
   ) t(rn) 
  where
   rn > 0	            
) print '1'