SELECT *, DATEDIFF(CURRENT_DATE,completed_coding) as oasis_diff
FROM #Request.prefix_db_lookup#.Coding_Request
WHERE Coding_Request.Deleted <> 1
AND (message_indicate NOT LIKE '%Identified%' OR message_indicate is null)
AND Request_Date >= now() - INTERVAL 2 month
AND (Coding_status like 'completed_coding' OR Coding_status like 'coding_review' OR Coding_status like 'waiting_for_OASIS' OR Coding_status like 'unable_to_complete_coding' OR Coding_status like 'unable_to_complete_OASIS')
AND DATEDIFF(CURRENT_DATE,Request_Date) >= 10
ORDER BY Created_Date ASC
SELECT *, DATEDIFF(now(),completed_1st_message_send) as waitdiff
FROM #Request.prefix_db_lookup#.Coding_Request
WHERE Coding_Request.Deleted <> 1
AND (message_indicate NOT LIKE '%Identified%' OR message_indicate is null)
AND Request_Date >= now() - INTERVAL 2 month
AND (Coding_status like 'completed_send_1st_approval' OR Coding_status like 'completed_1st_approval'
OR Coding_status like 'unable_to_complete_coding' OR Coding_status like 'unable_to_complete_OASIS'
OR Coding_status like 'unable_to_send_1st_approval'
OR Coding_status like 'unable_to_update_OASIS' OR Coding_status like 'unable_to_update_485' OR Coding_status like 'error' )
AND DATEDIFF(now(),Request_Date) >= 10
ORDER BY Created_Date ASC
Waiting for 1st approval
#Trim(Last_Name)# - #Trim(First_Name)# - #waitdiff# days - #completed_oasis# - #completed_1st_message_send#
UPDATE #Request.prefix_db_lookup#.Coding_Request
SET Coding_status = 'completed_final_reports_send',
completed_final_send = #now()# ,
cron_update =
WHERE ID IN ()
ids - #ids#