Zakljucak godine bez otvorenih stavki

update tDE_SetAccount

set acPermitPost = 'N'

 

update tDE_SetAccount

set acPermitPost = 'O'

where len(acAcct) > 3

 

update tDE_SetAccount

set acSubject = 'F'

 

update tDE_SetAccount

set acSubject = 'T'

where left(acAcct,2) in ('21','43','15')

 

update tDE_SetAccount

set acSubjAcct = 'N'