select Diagnosis.Diagnosis_ID,Diagnosis.ICD,Diagnosis.Diagnosis,Diagnosis.Dx_Order from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#' delete from #Request.prefix_db_agency#.diagnosis where diagnosis.Diagnosis_ID='#gridrow.Diagnosis_ID#'