2 spock
При загрузке из zip:
Msg 1018, Level 15, State 1, Line 5
Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.
Msg 1018, Level 15, State 1, Line 9
Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.
INSERT INTO _1SACCSEL
SELECT ACCID,DOCID,DATE_TIME_DOCID,NUMBER,CORNO,MAX(DT),MAX(KT) FROM
(
SELECT *',KT=' '
FROM #TMPACCSTBL TMP,_1SENTRY ENTRY(INDEX=ACCDTID)
WHERE ENTRY.ACCDTID=TMP.SUBID and ENTRY.DATE_TIME_DOCID>'20040701 0 0 ' AND ENTRY.DATE_TIME_DOCID<'20040801 0 0 '
UNION ALL
SELECT ',KT='*'
FROM #TMPACCSTBL TMP,_1SENTRY ENTRY(INDEX=ACCKTID)
WHERE ENTRY.ACCKTID=TMP.SUBID and ENTRY.DATE_TIME_DOCID>'20040701 0 0 ' AND ENTRY.DATE_TIME_DOCID<'20040801 0 0 '
) AS ACCSEL
GROUP BY ACCID,DOCID,DATE_TIME_DOCID,NUMBER,CORNO
Страницы: [1] 
У кого есть Windows 2003 X64 (R2) поделитесь файлами SqlSRV32.dll.. (число прочтений - 26594 )
