I have a stored procedure with a union in it that is returning an error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[SAP AG][SQLOD32 DLL][SAP DB]General error;-4024.
However, SQL runs fine in SQL Studio. I'm running 7.3.0.29 and the 7.3 ODBC
driver on Windows 2000. Any suggestions? The dbproc (stripped down to
minimum fields; parameters aren't used in this section of the dbproc) is
below:
CREATE DBPROC spCalendarGetList (
IN hint int,
IN selDate date,
IN fkGeneral int
) RETURNS CURSOR AS
DECLARE :$CURSOR CURSOR FOR
SELECT
tblCalendar.pkCalendar,
tblCalendar.Headline
FROM
Brian.tblCalendarDtl
INNER JOIN
Brian.tblCalendar on tblCalendarDtl.fkCalendar = tblCalendar.pkCalendar
INNER JOIN
Brian.tblUser ON tblCalendar.fkUser = tblUser.pkUser
INNER JOIN
Brian.tblEventType ON tblCalendar.fkEventType =
tblEventType.pkEventType
WHERE
tblCalendar.isApproved = true AND
DATE <= tblCalendarDtl.EventDate AND
DATEDIFF( DATE, tblCalendarDtl.EventDate ) < 7
UNION
SELECT
tblCalendar.pkCalendar,
tblCalendar.Headline
FROM
Brian.tblCalendarDtl
INNER JOIN
Brian.tblCalendar on tblCalendarDtl.fkCalendar = tblCalendar.pkCalendar
INNER JOIN
Brian.tblUser ON tblCalendar.fkUser = tblUser.pkUser
INNER JOIN
Brian.tblEventType ON tblCalendar.fkEventType =
tblEventType.pkEventType
WHERE
tblCalendar.isApproved = true AND
UPPER( tblEventType.EventType ) = 'DEADLINE' AND
DATE <= tblCalendarDtl.EventDate AND
DATEDIFF( DATE, tblCalendarDtl.EventDate ) < 30;
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
