Смертельный номер

[Андрій Жук]

select cast(RDB$SET_CONTEXT('USER_TRANSACTION','D', 
COALESCE(cast(RDB$GET_CONTEXT('USER_TRANSACTION','D') as integer),0) + 
1) as integer),
       cast(:DATE_FROM as DATE) + 
cast(COALESCE(cast(RDB$GET_CONTEXT('USER_TRANSACTION','D') as 
integer),0) as integer) as RES_DATE
from rdb$collations, rdb$collations
where
cast(:DATE_FROM as DATE) + 
cast(COALESCE(cast(RDB$GET_CONTEXT('USER_TRANSACTION','D') as 
integer),0) as integer) < cast(:DATE_TO as DATE)