Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
SELECT * FROM OPENQUERY(MAXPROD,' SELECT DISTINCT INC.TICKETID, INC.SEVERITY, INC.VENDOR, INC.VENDORTKTNO FROM INCIDENT INC LEFT OUTER JOIN ( SELECT DISTINCT TICKETID, MIN(CHANGEDATE) AS CHANGEDATE FROM TKSTATUS WHERE TKSTATUS.CLASS = 'INCIDENT' AND TKSTATUS.STATUS IN ('RESOLVED','CAN','CLOSED') GROUP BY TICKETID) STATUSCHANGEDT ON INC.TICKETID = STATUSCHANGEDT.TICKETID LEFT OUTER JOIN WOCHANGE WC ON INC.TICKETID = WC.ORGID WHERE INC.VENDOR IS NOT NULL AND INC.CREATIONDATE BETWEEN to_date'6/24/2010','mm/dd/yyyy') AND to_date('7/15/2010','mm/dd/yyyy')) Msg 102, Level 15, State 1, Line 13 Incorrect syntax near 'INCIDENT'.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.