execute block as
declare variable poss varchar(1000);
declare variable vall numeric (16,0);

begin
for execute statement
'select row_number() over (order by sum(pricetowdisc) desc) || '' место - '' || badgename || '' [Б+'' || caname||'']'' as poss, sum(pricetowdisc) as total from opers o
join contragents c on caid=opcaidown
join emps e on e.empid=o.empid
where opdate between dateadd(day,-30,current_timestamp) and current_timestamp and optype in (100,101,102,150,151,152)
group by caname,badgename
order by total desc'
WITH AUTONOMOUS TRANSACTION
ON EXTERNAL 'd:\basa\DBSERVER.FDB'
into :poss, :vall
do
begin
end