表 QYZLXY
ID int (主键)自增长
QYName nvarchar (企业名称)
QYID nchar (企业ID)
Year nvarchar (年)
month nchar (月)
Score float (分数)1 武汉出租一汽 1 2009 1 75
2 武汉出租一汽 1 2009 2 65.2
3 武汉出租二汽 2 2009 1 60
4 武汉出租二汽 2 2009 2 70
5 武汉出租二汽 2 2009 3 80
6 武汉出租三汽 3 2009 1 80
7 武汉出租三汽 3 2009 1 70要得到的结果是
年 总分 1月 2月 3月 ..... ... ... 12月语句 我会写
SELECT Year, SUM(Score) AS Scorecount, QYID,
ISNULL(SUM(CASE WHEN month = '1' THEN isnull(Score, 0) END), 0) AS a,
ISNULL(SUM(CASE WHEN month = '2' THEN isnull(Score, 0) END), 0) AS b,
ISNULL(SUM(CASE WHEN month = '3' THEN isnull(Score, 0) END), 0) AS c,
ISNULL(SUM(CASE WHEN month = '4' THEN isnull(Score, 0) END), 0) AS d,
ISNULL(SUM(CASE WHEN month = '5' THEN isnull(Score, 0) END), 0) AS e,
ISNULL(SUM(CASE WHEN month = '6' THEN isnull(Score, 0) END), 0) AS f,
ISNULL(SUM(CASE WHEN month = '7' THEN isnull(Score, 0) END), 0) AS g,
ISNULL(SUM(CASE WHEN month = '8' THEN isnull(Score, 0) END), 0) AS h,
ISNULL(SUM(CASE WHEN month = '9' THEN isnull(Score, 0) END), 0) AS i,
ISNULL(SUM(CASE WHEN month = '10' THEN isnull(Score, 0) END), 0) AS j,
ISNULL(SUM(CASE WHEN month = '11' THEN isnull(Score, 0) END), 0) AS k,
ISNULL(SUM(CASE WHEN month = '12' THEN isnull(Score, 0) END), 0) AS l
FROM QYZLXY
GROUP BY Year, QYID
这样 就可以得到结果但是 在Gridview 上 更新的话
相当于 更新 12条记录
到底怎么样 更新呢
ID int (主键)自增长
QYName nvarchar (企业名称)
QYID nchar (企业ID)
Year nvarchar (年)
month nchar (月)
Score float (分数)1 武汉出租一汽 1 2009 1 75
2 武汉出租一汽 1 2009 2 65.2
3 武汉出租二汽 2 2009 1 60
4 武汉出租二汽 2 2009 2 70
5 武汉出租二汽 2 2009 3 80
6 武汉出租三汽 3 2009 1 80
7 武汉出租三汽 3 2009 1 70要得到的结果是
年 总分 1月 2月 3月 ..... ... ... 12月语句 我会写
SELECT Year, SUM(Score) AS Scorecount, QYID,
ISNULL(SUM(CASE WHEN month = '1' THEN isnull(Score, 0) END), 0) AS a,
ISNULL(SUM(CASE WHEN month = '2' THEN isnull(Score, 0) END), 0) AS b,
ISNULL(SUM(CASE WHEN month = '3' THEN isnull(Score, 0) END), 0) AS c,
ISNULL(SUM(CASE WHEN month = '4' THEN isnull(Score, 0) END), 0) AS d,
ISNULL(SUM(CASE WHEN month = '5' THEN isnull(Score, 0) END), 0) AS e,
ISNULL(SUM(CASE WHEN month = '6' THEN isnull(Score, 0) END), 0) AS f,
ISNULL(SUM(CASE WHEN month = '7' THEN isnull(Score, 0) END), 0) AS g,
ISNULL(SUM(CASE WHEN month = '8' THEN isnull(Score, 0) END), 0) AS h,
ISNULL(SUM(CASE WHEN month = '9' THEN isnull(Score, 0) END), 0) AS i,
ISNULL(SUM(CASE WHEN month = '10' THEN isnull(Score, 0) END), 0) AS j,
ISNULL(SUM(CASE WHEN month = '11' THEN isnull(Score, 0) END), 0) AS k,
ISNULL(SUM(CASE WHEN month = '12' THEN isnull(Score, 0) END), 0) AS l
FROM QYZLXY
GROUP BY Year, QYID
这样 就可以得到结果但是 在Gridview 上 更新的话
相当于 更新 12条记录
到底怎么样 更新呢
我做的 是 统计的数据
问题是
我在 Gridview 中
需要 更新 12月份的 分数
它更新的是数据库里面的原始表
而且 需要更新12次
问题是怎么确定每条记录的唯一性呢
我在 实习
今天 遇见这个问题