- 博客(0)
- 资源 (3)
- 收藏
- 关注
交叉表 存储过程 实例
其中代码:SELECT CONVERT(nvarchar, e.bmdwdm) AS '报名单位代码', a.bmdwmc AS '报名单位', SUM(CASE e.khmkdm WHEN '01' THEN e.kkk ELSE 0 END) AS '汉字录入', SUM(CASE e.khmkdm WHEN '02' THEN e.kkk ELSE '' END) AS '基础知识', SUM(CASE e.khmkdm WHEN '03' THEN e.kkk ELSE '' END) AS '程序设计', SUM(CASE e.khmkdm WHEN '04' THEN e.kkk ELSE '' END) AS 'CAD', SUM(CASE e.khmkdm WHEN '05' THEN e.kkk ELSE '' END) AS '网页制作', SUM(CASE e.khmkdm WHEN '06' THEN e.kkk ELSE '' END) AS '多煤体', SUM(CASE e.bmdwdm WHEN e.bmdwdm THEN e.kkk ELSE 0 END) AS '合计' FROM (SELECT bmdwdm, khmkdm, COUNT(bmdwdm) AS kkk FROM tblkaosheng AS d GROUP BY bmdwdm, khmkdm) AS e INNER JOIN tblbmdw AS a ON a.bmdwdm = e.bmdwdm GROUP BY e.bmdwdm, a.bmdwmc
2009-07-10
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人