SELECT Assessment_New.Assessment_ID
FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_New.deleted <> 1
AND Assessment_New.Archive <> 1
AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%')
AND Assessment_New.Record_Creation_Date > '2017-10-01'
Group by Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End
UPDATE IGNORE #Request.prefix_db_agency#.Assessment_New SET
billed_date = '#DateFormat(form.billed_date,"yyyy-mm-dd")#',billed_end_date = '#DateFormat(form.billed_end_date,"yyyy-mm-dd")#',Invoice_number = '#form.Invoice_number#',
Agency_ID = #form.Agency_name#
WHERE Record_Creation_Date >= '#DateFormat(form.billed_date,"yyyy-mm-dd")#'
and Record_Creation_Date <= '#DateFormat(form.billed_end_date,"yyyy-mm-dd")#'
SELECT * FROM #Request.prefix_db_lookup#.Agency
WHERE status = 'active' order by Agency_Name ASC
Superadmin Home