解决方案 »
- sql2005查询结果导出为access
- 求一SQL语句
- 自定义函数的问题??
- 求触发器,A地有数据库Mac,B地也有Mac,如何实现A地的Mac增删改,B地的Mac也相应的增删改;B地的Mac增删改,A地的Mac也相应的增删改
- ado插入记录
- 有什么函数可以把日期型字段的年月日取出来,不要时间信息。
- 怎样有条件的复制本身表?
- 如何筛选多列的记录
- 请教SQL问题: 如当字段AA的值为‘1’时改变字段BB的值为‘2’。求用SELECT语句如果实现?
- 在写触发器时,对for update,insert,delete 与下面的if(....inserted).... if(....deleted) if(....updated)的关系
- sql server 如何将表中的字段类别分列显示
- 主键设计 自增长还是复合主键
这个语句我觉得最少要在WorkshopNo建有索引(或覆盖索引),然后使用如下:
SELECT SUM(CASE WHEN ClaimStatus in ('A1F','A2F') THEN 1 ELSE 0 END) AS 'WaitForA',
SUM(CASE WHEN ClaimStatus in('N','N1F','N2F') THEN 1 ELSE 0 END) AS 'WaitForT',
SUM(CASE WHEN ClaimStatus = 'E' THEN 1 ELSE 0 END) AS 'WaitForC',
SUM(CASE WHEN ClaimStatus = 'RE' THEN 1 ELSE 0 END) AS 'Rejected' ,
SUM(CASE WHEN ClaimStatus in('N1S','N2S') THEN 1 ELSE 0 END) AS 'PbWS'
FROM Claim AS Claim WHERE Claim.RequestType = 'CR'
AND ClaimStatus in ('A1F','A2F','NEW','N2F','N1F','E','RE','N1S','N2S')
AND exists(select 1 FROM User_Workshop AS B
WHERE UserID = 'ABC' and WorkshopNo=B.WorkshopId)