DELETE FROM #Request.prefix_db_agency#.Supply_Sched WHERE Supply_Sched_ID = #url.sid# SELECT pSchedules.Schedule_ID, pSchedules.Assmt_ID, pSchedules.Patient_ID, pPtPayer.Payer_ID, pPatients.Pt_Last AS Last_Name, pPatients.Pt_First AS First_Name, pSchedules.Visit_Date, pSchedules.Skill AS Visit_Type FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pSchedules.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID WHERE pSchedules.Schedule_ID = #url.ID# AND pSchedules.status = 0 AND pPatients.status < 2 AND pPtPayer.status < 2 GROUp BY pSchedules.Schedule_ID SELECT Supply_ID, Price, HCPCS, Revenue_Code FROM #Request.prefix_db_agency#.Supply WHERE Supply_ID = '#form.Supply_ID#' AND Agency_ID = #session.AgencyID# INSERT INTO #Request.prefix_db_agency#.Supply_Sched ( Supply_ID, Schedule_ID, Patient_ID, Assmt_ID,Total_Units,Total_Price,Revenue_Code,HCPCS,Payer_ID ) VALUES ( '#form.Supply_ID#', #form.Schedule_ID#, #form.Patient_ID#, #form.Assmt_ID#, #form.Total_Units#, #Total_Price#,'#Rev#','#HCPCS#',#form.Payer_ID# ) UPDATE #Request.prefix_db_agency#.Supply_Sched SET Total_Units = #form.Total_Units#, Total_Price = #form.price#, Revenue_Code = '#Rev#', HCPCS = '#HCPCS#' WHERE Supply_Sched_ID = #form.Supply_Sched_ID#