解决方案 »
- 关于sql 两表联立查询效率沃尔特
- 冰天雪地 裸体 跪求sql
- 100分解决就给,一个SQL问题
- 用VC调用openrowset从SQLServer导出查询的数据到Access, 结果这个程序不能在客户端电脑使用,解决就给分
- 菜鸟菜问:SQL表里的“”与NULL
- !!!急求一SQL语句!!!!
- SQL排序问题
- SQL Server 2000中自带的数据库Northwind中有getProductsByCategory这个存储过程吗?
- 很奇怪!SELECT patindex('%,______,%',',cbcyfy,')返回1
- view 和 cursor 使用上有什么不一样
- 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)