SELECT
Task_Input.INSTANCE_ID,
Task_Input.SCHEDULE_ID,
Task_Input.WORKFLOW_TEMPLATE_ID,
Task_Input.SCHEDULE_TIME,
Task_Input.EXECUTION_START_TIME,
Task_Input.EXECUTION_FINISH_TIME,
Task_Input.WORKENGINE_ID,
Task_Input.ADMIN_STATUS,
Task_Input.OPERATIONAL_STATUS,
Task_Input.SERVER_ID,
Task_Input.CRID
FROM Task_Input
INNER JOIN Scheduled_WorkFlow
ON Task_Input.SCHEDULE_ID=Scheduled_WorkFlow.SCHEDULE_ID
AND Task_Input.WORKFLOW_TEMPLATE_ID=Scheduled_WorkFlow.WORKFLOW_TEMPLATE_ID
LEFT JOIN Default_Task_Input
ON Task_Input.INSTANCE_ID=Default_Task_Input.INSTANCE_ID
WHERE ((((((((Task_Input.WORKENGINE_ID IN (1,1,2,2,3,3,4,4,1,2,3,4))
AND (Task_Input.SERVER_ID = -1))
AND (Task_Input.ADMIN_STATUS = 3))
AND (Task_Input.OPERATIONAL_STATUS = 3))
AND (Task_Input.SCHEDULE_TIME < '21-июн-2007 04:09:01 PM'))
AND (Scheduled_WorkFlow.ADMIN_STATUS = 3))
AND (Scheduled_WorkFlow.OPERATIONAL_STATUS = 3))
AND (Task_Input.SCHEDULE_TIME IS NOT NULL))
Server: Msg 241, Level 16, State 1, Line 1
Syntax error converting datetime from character string.
SELECT AdventNetErrorCode.ERRORCODE
FROM AdventNetErrorCode, MssqlErrorCode
WHERE MssqlErrorCode.ADVERRORCODE=AdventNetErrorCode.ERRORCODE
AND MssqlErrorCode.ERRORCODE=241
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MssqlErrorCode'.