back soft

مطالب مرتبط با «group by month access» در back soft | نویسنده: استخدام کار

Group by month and year of a date column

Vote count: 0 i have my query as following select Max(Reimbursement_EBSUtilization.Id) as Id,ProviderReimbursementRequest.Contractor_Id, Reimbursement_EBSUtilization.ServiceMonth, fContractor.ContractorName,Reimbursement_EBSUtilization.SD_Id, Max(StandardUnits) as StandardUnits, max(Rate) as Rate,sum(Reimbursement_EBSUtilization.UnitsDelivered) as UnitsDelivered , null as ReduceUnits, Cast(1 as BIT) as IsEbs, Reimbursement_EBSUtilization.BHFormName,fExpenseType.ExpenseType, case when Reimbursement_EBSUtilization.BHFormName is null then max(Rate) * sum(Reimbursement_EBSUtilization.UnitsDelivered) * ISNULL(max(Reimbursement_EBSUtilization.StandardUnits),0) else (case when fExpenseType.ExpenseT...

ادامه مطلب
خدمات نیلوبلاگ ساخت وبلاگ در نیلوبلاگ

جدیدترین مطالب منتشر شده

برچسب‌های مرتبط

group by month sql | group by month | group by month and year sql | group by month mysql | group by month in pivot table | group by month oracle | group by month access | group by month pandas | group by month and year pivot table | group by month and year