CREATE Procedure GetStatisticDetail
@EmployeeName varchar(50),
@BeginTime datetime,
@Endtime dateTime
AS
select
DHL=sum(case transit when 'DHL' then CWT else 0 end)+sum(case transit when 'DHL实重' then CWT else 0 end)+sum(case transit when 'DHL-CN' then CWT else 0 end)+sum(case transit when 'DHL-AE' then CWT else 0 end)+sum(case transit when 'DHL-MO' then CWT else 0 end)+sum(case transit when 'DHL-IDD' then CWT else 0 end),
UPS=sum(case transit when 'UPS' then CWT else 0 end)+sum(case transit when 'UPS蓝单' then CWT else 0 end)+sum(case transit when 'UPS-CN' then CWT else 0 end)+sum(case transit when 'UPS-MO' then CWT else 0 end)+sum(case transit when 'UPS-GZ' then CWT else 0 end),
EMS_TNT=sum(case transit when 'EMS' then CWT else 0 end)+sum(case transit when '中速TNT' then CWT else 0 end)+sum(case transit when 'EMS-HK' then CWT else 0 end)+sum(case transit when 'TNT-AE' then CWT else 0 end)+sum(case transit when 'TNT-HK' then CWT else 0 end)+sum(case transit when 'TNT-SZ' then CWT else 0 end)+sum(case transit when 'TNT-SZ经济快递' then CWT else 0 end)+sum(case transit when 'EMS-HK(万用箱)' then CWT else 0 end),
Fedex=sum(case transit when 'fedex' then CWT else 0 end)+sum(case transit when 'K空运' then CWT else 0 end)+sum(case transit when 'SL专线' then CWT else 0 end)+sum(case transit when 'TW专线' then CWT else 0 end)+sum(case transit when 'HK专线' then CWT else 0 end)+sum(case transit when 'Q汽运' then CWT else 0 end)+sum(case transit when 'DPEX' then CWT else 0 end)+sum(case transit when 'Z专线' then CWT else 0 end)+sum(case transit when 'HK进口' then CWT else 0 end)+sum(case transit when 'CITYLINK' then CWT else 0 end)+sum(case transit when 'FEDEX-AE' then CWT else 0 end)
,u.*from Checkin as cinner join [Users]as u on u.userId=c.User.Id
解决方案 »
- 急需解决的一个问题~~!!WEB高手进~~~!!
- 错误 1 找不到类型或命名空间名称“DotNetTextBox”(是否缺少 using 指令或程序集引用?)
- 如何判断我的Office是否是完整安装,即是否安装了office应用程序接口
- 常见的面试问题,有几人能答出来?
- 日期各种格式之间的转换问题??
- 求助:页面导航多参数传递的问题.
- 请问大家一个小问题,谢谢帮忙~~
- 文件上传研究
- 大家能不能谈一下 Web Matrix?
- 关于DropDownList模板列的数据读取问题?解决问题,高分相送(在线等)
- sql问题......................哪位大仙过来指点下
- checkbox 怎么绑定数据
end ) from A as a inner join B as b
on a.XTBH=b.AXTBH