SELECT pCMS4857.*,pAssessments.* ,pPatients.Patient_ID FROM #Request.prefix_db_agency#.pCMS4857 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pCMS4857.Assmt_ID JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_Id = pAssessments.Patient_Id JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAdmit.Patient_ID WHERE pPatients.status = 0 AND pAssessments.status = 0 AND pCMS4857.status = 0 AND pCMS4857.Form_Type = 'Form 485' AND pCMS4857.Assmt_ID = AND DATE_FORMAT(pCMS4857.Date_Change, "%Y-%m-%d") = CURDATE() GROUP BY pCMS4857.Assmt_ID ORDER BY pCMS4857.Date_Change DESC SELECT * FROM #Request.prefix_db_agency#.pCareplan WHERE Status = 0 AND Assmt_ID = AND pCareplan.CMSOrder_ID = 0 AND DATE_FORMAT(pCareplan.Date_Create, "%Y-%m-%d") = CURDATE() SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Status = 0 AND Assmt_ID = AND pProblem.CMSOrder_ID = 0 AND DATE_FORMAT(pProblem.Date_Create, "%Y-%m-%d") = CURDATE() SELECT * FROM #Request.prefix_db_agency#.pPtmeds WHERE Status = 0 AND Patient_ID = AND pPtmeds.CMSOrder_ID = 0 AND DATE_FORMAT(pPtmeds.Record_Creation_Date, "%Y-%m-%d") = CURDATE() SELECT * FROM #Request.prefix_db_agency#.pPtPayer WHERE Patient_ID = AND Status = 0 INSERT INTO #Request.prefix_db_agency#.pCMS4857 (Assmt_ID, Status,Form_Type, Date_Sent, Insured_HIC, Date_Admit, Certification_From, Certification_To, Pt_Agy_ID, Agy_CCN, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Agy_Name, Agy_Street, Agy_City, Agy_State, Agy_Zip, Agy_Phone, Agy_NPI, Pt_DOB, Pt_Gender, Order_description, Discharge_Plan, Clinician_Signature, Render_Phys_ID, MD_Homebound, MD_Clinical_Condition, Date_Create, Created_by, Date_Change, Change_by) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT last_insert_id() AS id