摘要:
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 阅读全文