update acmast set T = 1, isclosed = 1, edt= getdate() where acmastid not in (select isnull(acsubid,'') 
from voucher where r = 0) AND ACOPENDT < GETDATE()-3 AND ACPARENTID = '245' and type=3

UPDATE PLEDGEGOLD SET R= 1, T = 1 ,edt= getdate() WHERE AcmastId IN (SELECT ACMASTID FROM AcMast WHERE T = 1)