We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
;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.
|SQL select to return records that don't exist (crosjoin?)||3||38|
|Select Sum query with group by||8||42|
|Windows Server 2003 STD SP2 as a member server of 2016 domain||11||84|
|SQL Server Agent "Access Denied" Error||3||31|
Join the community of 500,000 technology professionals and ask your questions.