摘要: DECLARE @CurrFunName NVARCHAR(100) DECLARE myCursorKPI2 CURSOR FOR SELECT Name FROM FunctionList OPEN myCursorKPI2 FETCH NEXT FROM myCursorKPI2 INTO @CurrFunName WHILE @@FETCH_STATUS = 0 --返回被 FETCH 语句执行的最后游标的状态,而不是任何当前被连接打开的游标的状态。 BEGIN BEGIN PRINT @CurrFunName EXEC ComputeKPIPointByFunYearMon @CurrFunName,@Year,@Month END FETCH NEXT FROM myCursorKPI2 INTO @CurrFunName END 阅读全文
posted @ 2009-12-29 20:25 邑尘 阅读(285) 评论(0) 推荐(0) 编辑