Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
;WITH MyCTE AS ( SELECT * FROM ( SELECT * FROM emdb.dbo.calendarview )p UNPIVOT ( EventDate FOR DateDescription in ([Appraisal Ordered],[Closing Date],[Application Signed],[Appraisal Recieved] ,[Approval To Close],[Insurance Ordered],[Title Ordered]) ) as unpvt ) insert into outlookreport.dbo.calendar (eventdate,item,xrefid) SELECT M.EventDate, M.DateDescription, T.xrefid FROM emdb.dbo.calendarview T JOIN MyCTE M ON T.xrefid = M.xrefid WHERE NOT EXISTS(SELECT 1 FROM outlookreport.dbo.calendar WHERE eventdate = M.EventDate AND xrefid = T.xrefid);
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.