TEXT TO lcSelect TEXTMERGE NOSHOW PRETEXT 7    
SELECT 
<skiped>, 
hd.kod,
0 as sel,
0 as num 
case when Hd.isflag&2 >0 then '&#254;' else CHR(32) end::char(1) as isbit1 ,
case when Hd.isflag&128 >0 then '&#254;' else CHR(32) end::char(1) as isbit7  -- и т.д. для всех значимых бит
from hd
inner join hdd on hdd.kodhd = hd.kod
left join <skiped>
where hd.kodtype in (4,3)        
and hd.begdata between '2013-02-22' and '2013-02-22'
GROUP by <skiped>
ORDER by <skiped>
ENDTEXT
SQLExecute(lcSelect,'curData')

select events.kodhd, min(events.kodtype) as typeoper, 
CASE 
when events.kodtype = 268 or events.kodtype = 274 then 13 
when events.kodtype = 269 or events.kodtype = 265 then 14 
when events.kodtype = 270 or events.kodtype = 276 then 15 
when events.kodtype = 271 or events.kodtype = 277 then 16 
when events.kodtype = 272 or events.kodtype = 278 then 17 
when events.kodtype = 273 or events.kodtype = 279 then 18 
when events.kodtype = 280 then 22 
end as bit_number,
 max(trim(to_char(events.stamp,'HH:MI:SS'),'both')) as timet,
 max(trim(to_char(events.stamp,'HH:MI:SS'),'both') || ' > '||TRIM(typeop.name) || 
 case when flagoper = 0 then ' - Отменена операции!!!' else '' end)::varchar(200) as operation 
from events inner join typeop on events.kodtype = typeop.kod 
where events.kodhd = ХХХХХХХХ
group by 1,3
order by timet

with w as (
SELECT
 <здесь выборка для документов реестра>
)
select w.*,bit22,bit13,bit14,bit15,bit16,bit17,bit18
from w left join (
select kodhd, max(case when kodtype = 280 then to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit22,
max(case when kodtype = 274 or kodtype = 268 then  to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit13,
max(case when kodtype = 275 or kodtype = 269 then  to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit14,
max(case when kodtype = 276 or kodtype = 270 then  to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit15,
max(case when kodtype = 277 or kodtype = 271 then  to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit16,
max(case when kodtype = 278 or kodtype = 272 then  to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit17,
max(case when kodtype = 279 or kodtype = 273 then  to_char(stamp,'HH:MI:SS') || ' > ' ||name else chr(32) end) as bit18
from (
select events.kodhd, events.kodtype, 
max(events.stamp) as stamp, max(trim(typeop.name)) as name 
from events inner join typeop on events.kodtype = typeop.kod 
where events.kodtype > 268 and events.kodhd in (select ttn_kod
from w)
group by 1,2
order by 3 
) as foo
group by 1 
) as foo1 on w.ttn_kod = foo1.kodhd