Select case r.Measure When '.25' Then Sum(s.Total_Units) When 'visit' Then Count(s.ScheduleItems_ID) When '1' Then Cast(Sum(s.Total_Hours) AS UNSIGNED) End as weekunits From #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Revenue_Code r Where r.Rev_CodeID = s.Rev_CodeID AND s.Patient_ID='#patid#' AND s.Payer_ID='#payid#' AND s.Rev_CodeID = '#revcode_id#' AND s.Visit_Date BETWEEN '#Startdate#' AND '#Enddate#' Select a.Time_Frame, a.Units, s.Total_Units, a.StartDate, a.EndDate, ABS(floor(DateDiff(a.StartDate , a.EndDate)/7)) as countweeks From #Request.prefix_db_agency#.authorizations a, #Request.prefix_db_agency#.ScheduleItems s Where a.Payer_ID = s.Payer_ID AND a.Rev_CodeID = s.Rev_CodeID AND a.Patient_ID='#patid#' AND a.Payer_ID='#payid#' AND a.Rev_CodeID = '#revcode_id#' and a.Auth_ID='#Aid#' SELECT v.Assessment_ID,v.Revenue_Code,v.HCPCS_Code,v.Units,v.Units_Extra, MIN(v.Week_Start) AS Week_Start,MAX(v.Week_End) AS Week_End, v.Rev_CodeID, ABS(floor(DateDiff(v.Week_Start , v.Week_End)/7)) as countweeks FROM #Request.prefix_db_agency#.visit_orders v, #Request.prefix_db_agency#.ScheduleItems s WHERE v.Assessment_ID = '#AssessmentID#' AND v.Rev_CodeID = s.Rev_CodeID Group BY v.Week_Start ORDER BY v.Week_End ASC SELECT v.Assessment_ID,v.Revenue_Code,v.HCPCS_Code,v.Units,v.Units_Extra,v.Week_Start,v.Week_End,v.Rev_CodeID, ABS(floor(DateDiff(v.Week_Start , v.Week_End)/7)) as countweeks FROM #Request.prefix_db_agency#.visit_orders v, #Request.prefix_db_agency#.ScheduleItems s WHERE v.Assessment_ID = '#Assessment_ID#' AND v.Rev_CodeID = s.Rev_CodeID AND v.Rev_CodeID = '#revcode_id#' and v.Visit_OrderID = '#Visit_order_ID#' Select s.* From #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.Revenue_Code r Where r.Rev_CodeID = s.Rev_CodeID AND s.Assessment_ID = '#Assid#' ---> AND s.Rev_CodeID = '#revcode_id#' AND s.Visit_Date BETWEEN '#Startdate#' AND '#Enddate#' SELECT Patient_ID, Auth_ID, Rev_CodeID, Payer_ID, Revenue_Code FROM #Request.prefix_db_agency#.authorizations WHERE Patient_ID = '#patid#' And Auth_ID='#id#'