想实现的功能是按照一系列条件,搜索出一个数据集,此数据集已经排好序了,这段过程就是实现同分数的同名次,
……
DECLARE @Grade1 int
DECLARE @Grade2 int
DECLARE @j int
DECLARE @tmp int
DECLARE order_cur1 CURSOR FOR
SELECT Grade,[Order] FROM Grade_Grade gg,gbxx g
WHERE gg.CardID = g.jgzh AND g.dwid = @OfficeID AND gg.HistoryID = @HistoryID ORDER BY gg.Grade DESC
FOR UPDATE OF [order]
OPEN order_cur1FETCH NEXT FROM order_cur1 INTO @Grade1,@j
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM order_cur1 INTO @Grade2,@tmp
IF(@Grade1=@Grade2)
UPDATE Grade_Grade SET [order] = @j WHERE CURRENT OF order_cur1
/*SET @Grade1 = @Grade2*/ //打开这一句就出现问题
END
CLOSE order_cur1
DEALLOCATE order_cur1
……
DECLARE @Grade1 int
DECLARE @Grade2 int
DECLARE @j int
DECLARE @tmp int
DECLARE order_cur1 CURSOR FOR
SELECT Grade,[Order] FROM Grade_Grade gg,gbxx g
WHERE gg.CardID = g.jgzh AND g.dwid = @OfficeID AND gg.HistoryID = @HistoryID ORDER BY gg.Grade DESC
FOR UPDATE OF [order]
OPEN order_cur1FETCH NEXT FROM order_cur1 INTO @Grade1,@j
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM order_cur1 INTO @Grade2,@tmp
IF(@Grade1=@Grade2)
UPDATE Grade_Grade SET [order] = @j WHERE CURRENT OF order_cur1
/*SET @Grade1 = @Grade2*/ //打开这一句就出现问题
END
CLOSE order_cur1
DEALLOCATE order_cur1
解决方案 »
- 求开源在线纯web word/excel编辑器,付费的也可以
- asp.net里的Flash问题
- discuz 2.0 首页改版后出错,急,我增加了模块
- asp.net中运用XML的问题
- 怎么没有microsoft.web.services2命名啊?
- AjaxPro初学者的问题
- 值转换的问题!在2005.net请高手指点????????????100分送上
- 开了一个vs中C#项目中的asp应用程序出现的问题
- 要结贴也请各位老大?把我这个问题给解决吧!刷新网页的问题!平安夜快乐!
- 如何让程序知道连接的文件不存在,自动转到别的页上呢?
- ASP.NET中Cookie的问题,关于同一台机器只能有维护一个身份的问题
- asp.net中插入数据到Excel的问题。
update student set score =
(select count(*)+1
from student s1
where student.score < s1.score)