Код

set nocount on select * from OPENQUERY(ORA, 'select ALT_DART_NO, ALT_TYPE from DS_ALTERDART where ORG_DART_NO = ''**********''') 

Код

set statistics time on
set nocount on
select
  ORCL.ABLG_NO
, ORCL.ADT
, ORCL.ABAY_TO
, ORCL.ADART_NO
, ORCL.ADART_DESCR
, ORCL.APRICE
, ORCL.AQTY
, tmz.descr as ТМЦ
from
  OPENQUERY(ORA, '
select
  TRANS.blg_no AS ABLG_NO
, trunc(TRANS.reserve_dt,''DDD'') AS ADT
, SUPL.BAY_TO AS ABAY_TO
, TRANS.dart_no AS ADART_NO
, TRANS.dart_desc AS ADART_DESCR
, to_char(TRANS.dart_price,''999999999.99'') as APRICE
, sum(TRANS.qty) as AQTY
from
  DS_PURCH PURCH
, DS_TRANS TRANS
, DS_SUPL SUPL
where
PURCH.purchase_no = TRANS.purchase_no and
PURCH.purchase_seс = TRANS.purchase_seс and
TRANS.supl = SUPL.supl
and trunc(TRANS.reserve_dt,''DDD'') between  to_date(''16.04.08'',''DD.MM.YY'') and  to_date(''16.04.08'',''DD.MM.YY'')
group by TRANS.reserve_dt, TRANS.blg_no, SUPL.BAY_TO, TRANS.dart_no,  TRANS.dart_desc, TRANS.dart_price
') as ORCL
left join
  [account_db].[dbo].sc148 as tmz(nolock) on tmz.descr = ORCL.DART_NO 

Код

SQL Server parse and compile time:
   CPU time = 0 ms, elapsed time = 2575 ms.
SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.
SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.
SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 1467 ms.