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.Assessment_ID = '#Assid#' 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 Rev_CodeID, Rev_Code, HCPCS, Visit_Type, Description FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID ='#Session.AgencyID#' AND Payer_ID ='#TempPayid#' AND Rev_CodeID='#Revid#' And EClaim_Price IS NOT NULL And Quick_Books_Price IS NOT NULL Order by Visit_Type ASC SELECT Rev_CodeID, Rev_Code, HCPCS, Visit_Type, Description FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID ='#Session.AgencyID#' AND Payer_ID ='#TempPayid#' AND Rev_CodeID='#Revid#' And EClaim_Price IS NOT NULL And Quick_Books_Price IS NOT NULL Order by Visit_Type ASC SELECT Rev_CodeID, Rev_Code, HCPCS, Visit_Type, Description FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID ='#Session.AgencyID#' AND Payer_ID = '#Payid#' and Rev_CodeID= '#Revid#' And EClaim_Price IS NOT NULL And Quick_Books_Price IS NOT NULL Order by Visit_Type ASC