22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM CSKH ccc
INNER JOIN ( SELECT a.fgsid ,
SUM(a.je) AS je ,
COUNT(*) AS kll ,
SUM(bs) AS bs ,
SUM(sl) AS sl ,
SUM(ml) AS ml
FROM ( SELECT fgsid ,
lsh ,
SUM(je) AS je ,
SUM(sl) AS sl ,
COUNT(*) AS bs ,
SUM(ml) AS ml
FROM fgs_xsd (NOLOCK)
WHERE kdrq BETWEEN '2012-12-01'
AND DATEADD(day, 1, '2012-12-11')
GROUP BY fgsid ,
lsh
) a
GROUP BY a.fgsid
) b
ON ccc.id = b.fgsid
CREATE NONCLUSTERED INDEX idx_fgs_xsd_kdrq1
ON [dbo].[fgs_XSD] ([KDRQ])
INCLUDE ([FGSID],[LSH],[SL],[JE],[ML])
SELECT a.fgsid , (select mc from CSKH where CSKH.id = a.fgsid ) as mc ,
SUM(a.je) AS je ,
COUNT(*) AS kll ,
SUM(bs) AS bs ,
SUM(sl) AS sl ,
SUM(ml) AS ml INTO #abcd
FROM ( SELECT fgsid ,
lsh ,
SUM(je) AS je ,
SUM(sl) AS sl ,
COUNT(*) AS bs ,
SUM(ml) AS ml
FROM fgs_xsd (NOLOCK)
WHERE kdrq BETWEEN '2012-12-01'
AND DATEADD(day, 1, '2012-12-11')
GROUP BY fgsid ,
lsh
) a
GROUP BY a.fgsid