Запускаю такой запрос из QA:

select SC351.SP1628,
SC351.PARENTID,
SC391.PARENTEXT,
convert(numeric(10, 2), _1SCONST.VALUE) ,
convert(numeric(10, 2), _1SCONST1.VALUE) * SC391.SP1659 ,
convert(numeric(10, 2), _1SCONST2.VALUE) * SC391.SP379 ,
convert(numeric(10, 2), _1SCONST3.VALUE) * 0,
convert(numeric(10, 2), _1SCONST4.VALUE) * SC391.SP8184 ,
_1SCONST5.VALUE,
SC391.SP1666,
SC391.ID,
SC391.SP8187,
SC391.SP8184,
convert(numeric(10, 2), _1SCONST6.VALUE),
SC391.SP1659,
SC391.SP379,
SC391.SP1658
from SC391(NOLOCK)
left outer join
SC351(NOLOCK) on SC391.PARENTEXT=SC351.ID
left outer join
_1SCONST(NOLOCK) on (_1SCONST.ID = 1653 and _1SCONST.OBJID = SC391.ID and convert(CHAR(, _1SCONST.DATE, 112) + convert(CHAR(10), _1SCONST.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 1653 and OBJID = SC391.ID and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST.DOCID = (select max(DOCID) from _1SCONST _1SCONST_OTHER1 where ID = 1653 and OBJID = SC391.ID and _1SCONST.DATE = DATE and _1SCONST.TIME = TIME))
left outer join
_1SCONST _1SCONST1(NOLOCK) on (_1SCONST1.ID = 1653 and _1SCONST1.OBJID = SC391.ID and convert(CHAR(, _1SCONST1.DATE, 112) + convert(CHAR(10), _1SCONST1.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 1653 and OBJID = SC391.ID and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST1.DOCID = (select max(DOCID) from _1SCONST _1SCONST1_OTHER1 where ID = 1653 and OBJID = SC391.ID and _1SCONST1.DATE = DATE and _1SCONST1.TIME = TIME))
left outer join
_1SCONST _1SCONST2(NOLOCK) on (_1SCONST2.ID = 1653 and _1SCONST2.OBJID = SC391.ID and convert(CHAR(, _1SCONST2.DATE, 112) + convert(CHAR(10), _1SCONST2.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 1653 and OBJID = SC391.ID and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST2.DOCID = (select max(DOCID) from _1SCONST _1SCONST2_OTHER1 where ID = 1653 and OBJID = SC391.ID and _1SCONST2.DATE = DATE and _1SCONST2.TIME = TIME))
left outer join
_1SCONST _1SCONST3(NOLOCK) on (_1SCONST3.ID = 1653 and _1SCONST3.OBJID = SC391.ID and convert(CHAR(, _1SCONST3.DATE, 112) + convert(CHAR(10), _1SCONST3.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 1653 and OBJID = SC391.ID and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST3.DOCID = (select max(DOCID) from _1SCONST _1SCONST3_OTHER1 where ID = 1653 and OBJID = SC391.ID and _1SCONST3.DATE = DATE and _1SCONST3.TIME = TIME))
left outer join
_1SCONST _1SCONST4(NOLOCK) on (_1SCONST4.ID = 1653 and _1SCONST4.OBJID = SC391.ID and convert(CHAR(, _1SCONST4.DATE, 112) + convert(CHAR(10), _1SCONST4.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 1653 and OBJID = SC391.ID and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST4.DOCID = (select max(DOCID) from _1SCONST _1SCONST4_OTHER1 where ID = 1653 and OBJID = SC391.ID and _1SCONST4.DATE = DATE and _1SCONST4.TIME = TIME))
left outer join
_1SCONST _1SCONST5(NOLOCK) on (_1SCONST5.ID = 8154 and _1SCONST5.OBJID = SC391.PARENTEXT and convert(CHAR(, _1SCONST5.DATE, 112) + convert(CHAR(10), _1SCONST5.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 8154 and OBJID = SC391.PARENTEXT and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST5.DOCID = (select max(DOCID) from _1SCONST _1SCONST5_OTHER1 where ID = 8154 and OBJID = SC391.PARENTEXT and _1SCONST5.DATE = DATE and _1SCONST5.TIME = TIME))
left outer join
_1SCONST _1SCONST6(NOLOCK) on (_1SCONST6.ID = 1653 and _1SCONST6.OBJID = SC391.ID and convert(CHAR(, _1SCONST6.DATE, 112) + convert(CHAR(10), _1SCONST6.TIME) = (select max(convert(CHAR(, DATE, 112) + convert(CHAR(10), TIME)) from _1SCONST where ID = 1653 and OBJID = SC391.ID and (DATE < '20010601' or DATE = '20010601' and TIME <= 936600000)) and _1SCONST6.DOCID = (select max(DOCID) from _1SCONST _1SCONST6_OTHER1 where ID = 1653 and OBJID = SC391.ID and _1SCONST6.DATE = DATE and _1SCONST6.TIME = TIME))

Получаю такой ответ:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process хх generated fatal exception c0000091 EXCEPTION_FLT_OVERFLOW. SQL Server is terminating this process.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionWrite (WriteFile()).
[Microsoft][ODBC SQL Server Driver]Communication link failure

Connection Broken

Если сразу же ещё раз запускаю, то

Changed language setting to us_english.
Changed language setting to us_english.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process хх generated fatal exception c0000091 EXCEPTION_FLT_OVERFLOW. SQL Server is terminating this process.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionCheckForData (PeekNamedPipe()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

Connection Broken

В случае сетевой библиотеки TCP/IP :
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData ((null)()).
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

Connection Broken

Пробовал на разном железе - одно и тоже. Раньше не пробовал. Этот запрос генерирует 1С:Предприятие. Использую SQL 7.0 SP1 на NT Server 4.0. База 460 Мб. Таблица _1SCONST -233000 записей. ODBC из MDAC 2.5. Если убрать один join - всё работает.
План запроса не создаётся.

Чё делать -то, кто скажет. С чем енто кушать? Поможитя - 1с не работает.

упс.. SP3 решил проблемку.