我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据

大佬教程收集整理的这篇文章主要介绍了我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

如何解决我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据？

开发过程中遇到我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据的问题如何解决？下面主要结合日常开发的经验，给出你关于我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据的解决方法建议，希望对你解决我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据有所启发或帮助；

我希望发票金额列的“May 1”是动态的，基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据，例如，如果我选择bcd.processeddate 5/15/2020 至 5/15/2021，各列应显示 @H_574_3@may 15 invoice amount、june 15 invoice amount 等。

有人可以指导我朝着正确的方向前进吗？

SELEct 
       case when cagp.amb_memberID is not null then cagp.amb_memberID else case when cap.amb_memberID is not null then cap.amb_memberID else ca.amb_memberID end end as [ParentID],case when cagp.amb_memberID is not null then cagp.name else case when cap.amb_memberID is not null then cap.name else ca.name end end as [Parentname],bcd.MemberID,bcd.MemberStationCode,ca.name,sum(case when year(processeddatE)=2020 and month(processeddatE)=5 then (invoiceamount) else 0 end) as "May 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=6 then (invoiceamount) else 0 end) as "Jun 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=7 then (invoiceamount) else 0 end) as "Jul 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=8 then (invoiceamount) else 0 end) as "Aug 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=9 then (invoiceamount) else 0 end) as "Sep 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=10 then (invoiceamount) else 0 end) as "Oct 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=11 then (invoiceamount) else 0 end) as "Nov 1 invoiceamount",sum(case when year(processeddatE)=2020 and month(processeddatE)=12 then (invoiceamount) else 0 end) as "Dec 1 invoiceamount",sum(case when year(processeddatE)=2021 and month(processeddatE)=1 then (invoiceamount) else 0 end) as "Jan 1 invoiceamount",sum(case when year(processeddatE)=2021 and month(processeddatE)=2 then (invoiceamount) else 0 end) as "Feb 1 invoiceamount",sum(case when year(processeddatE)=2021 and month(processeddatE)=3 then (invoiceamount) else 0 end) as "Mar 1 invoiceamount",sum(case when year(processeddatE)=2021 and month(processeddatE)=4 then (invoiceamount) else 0 end) as "Apr 1 invoiceamount",sum(case when year(processeddatE)=2021 and month(processeddatE)=5 then (invoiceamount) else 0 end) as "May 1 invoiceamount"
from serviceconnection_Hist bcd 
left outer join CRM_Account ca
       on bcd.MemberID=ca.amb_memberID and ca.statecodename='Active' and ca.statecode=0 and ca.statuscode=1
left outer join CRM_Account cap on ca.parentaccountID=cap.accountID and cap.statecode=0 and cap.statuscode=1
left outer join CRM_Account cagp on cap.parentaccountID=cagp.accountID and cagp.statecode=0 and cagp.statuscode=1
where bcd.processeddate >= '5/1/2020' and bcd.processeddate< '5/1/2021' and MemberID<>'' and ca.statecode=0 and ca.statuscode=1
group by 
       case when cagp.amb_memberID is not null then cagp.amb_memberID else case when cap.amb_memberID is not null then cap.amb_memberID else ca.amb_memberID end end,case when cagp.amb_memberID is not null then cagp.name else case when cap.amb_memberID is not null then cap.name else ca.name end end,ca.name
order by 1,2,bcd.MemberID

解决方法

暂无找到可以解决该程序问题的有效方法，小编努力寻找整理中！

如果你已经找到好的解决方法，欢迎将解决方案带上本链接一起发送给小编。

小编邮箱:dio#foxmail.com (将#修改为@）

大佬总结

以上是大佬教程为你收集整理的我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据全部内容，希望文章能够帮你解决我希望发票金额列的“5 月 1 日”基于 bcd.processeddate '5/1/2020 between '5/1/2021' 一年的数据所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。