DECLARE @dDate1 CHAR( 25 ), @dDate2 CHAR( 25 )
SET @dDate1 = '2005-09-30'
SET @dDate2 = '2005-10-01'

SELECT TOP  1 
 ent.name AS entname,
 dev.voltage,
 dev.id AS dev_id,
 dev.name AS devname,
 zvkn.note_text,
 zvkcat.ident AS category,
 rep.ident AS repair,
 zvkb.PlanDateBegin AS dtPlBeg,
 zvkb.PlanDateEnd AS dtPlEnd,
 zvkb.FactRepairDateBegin AS dtFactBeg,
 zvkb.FactRepairDateEnd AS dtFactEnd,
 zvkb.id AS zvk_id
 FROM
  cache..zvk.zvkbody AS zvkb,
  cache..zvk.enterprise AS ent,
  cache..zvk.zvkcategory AS zvkcat,
  cache..zvk.repairtype AS rep,
  cache..zvk.devicetype AS devt,
  cache..zvk.zvkbody_note AS zvkn,
  cache..zvk.notetype AS nt,
  (SELECT device.id, device.name, device.devicetype, deviceBD.voltage
    FROM cache..zvk.device AS device LEFT JOIN cache..sqluser.devicebd AS deviceBD
    ON device.shifr=devicebd.shifr) AS dev
 WHERE
  zvkb.enterprise=ent.id AND
  zvkb.device=dev.id AND
  zvkb.id=zvkn.zvkbody AND
  zvkn.note_notetype=nt.id AND
  nt.ident='ЗВК_СДР' AND
  zvkb.zvkcategory=zvkcat.id AND
  zvkb.repairtype=rep.id AND
  dev.devicetype=devt.id AND
  devt.ident='ЛЭП' AND
  ( zvkb.factrepairdatebegin>=RTRIM(@dDate1) AND
    zvkb.factrepairdatebegin<=RTRIM(@dDate2) OR
    zvkb.factrepairdateend>=RTRIM(@dDate1) AND
    zvkb.factrepairdateend<=RTRIM(@dDate2) )
 ORDER BY dev.name

Но получаю ошибку:
ODBC: Msg  0 , Level  19 , State  1 
SqlDumpExceptionHandler: Process  54  generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Server: Msg  7321 , Level  16 , State  2 , Line  12 
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'. 
[OLE/DB provider returned message: [Caché ODBC][State :  37000 ][Native Code  23 ]
[C:\PROGRA~ 1 \MICROS~ 2 \MSSQL\binn\sqlservr.exe]
[SQLCODE: <- 23 >:<Label is not listed in FROM>]
[Cache Error: <<SYNTAX>errdone+ 1 ^%qaqqt>]
[Details: <FLoop - func = PP>]
[%msg: < SQL ERROR # 23 : Label ` 3 ,3SQLUSER.QRY1646ZVKB' is not listed in FROM^SELECT Col1645 ,>]]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80040e14].

SELECT TOP  1  techviol.name, apv.name AS apv, classif.name AS classif, typeviol.name AS typeviol
 FROM cache..sqluser.techviol AS techviol, cache..sqluser.apv AS apv, cache..sqluser.classif AS classif,
      cache..sqluser.typeviol AS typeviol
 WHERE techviol.apv=apv.id AND techviol.classif=classif.id

SELECT TOP  1  techviol.name, apv.name AS apv, classif.name AS classif, typeviol.name AS typeviol
 FROM cache..sqluser.techviol AS techviol, cache..sqluser.apv AS apv, cache..sqluser.classif AS classif,
      cache..sqluser.typeviol AS typeviol
 WHERE techviol.apv=apv.id AND techviol.classif=classif.id AND techviol.typeviol=typeviol.id

Ошибка:
Server: Msg  7321 , Level  16 , State  2 , Line  1 
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'. 
[OLE/DB provider returned message: [Caché ODBC][State :  37000 ][Native Code  23 ]
[C:\PROGRA~ 1 \MICROS~ 2 \MSSQL\binn\sqlservr.exe]
[SQLCODE: <- 23 >:<Label is not listed in FROM>]
[Cache Error: <<SYNTAX>errdone+ 1 ^%qaqqt>]
[Details: <FLoop - func = PP>]
[%msg: < SQL ERROR # 23 : Label ` 3 ,3SQLUSER.QRY1019TECHVIOL' is not listed in FROM^SELECT Col1017 ,>]]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80040e14].