报表SQL语句整理收集.pdfVIP

select dbo . fun_money2str ( SUM( PurchaseAmount )) PurchaseAmount , dbo . fun_money2str ( SUM( DistributeAmount )) DistributeAmount , dbo . fun_money2str ( SUM( WarehouseAmount )) WarehouseAmount , dbo . fun_money2str ( SUM( PayedAmount )) PayedAmount , dbo . fun_money2str ( SUM( WithdrawAmount )) WithdrawAmount , count ( Distinct DistributorID ) DistributorCount from dbo . REP_DistributorAreaMedtype dam join funGetSubZoneByUID ( CGZX , 0 ) SZ