SELECT count(*) as visitcount from #Request.prefix_db_agency#.PatientVisitDetails where Assessment_Id = '#session.cs.AssessmentId#' and ScheduleItems_ID != 0 and Type != 'vital sign' and Type != 'wound' SELECT count(*) as careplancount from #Request.prefix_db_agency#.Pathway_Details where Assessment_Id = '#session.cs.AssessmentId#' and Type != 'vital sign';