GO
SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

CREATE PROCEDURE [DBO].[SP_SY_TIMES0]  
  @BAH000  VARCHAR(20)  
 WITH ENCRYPTION
AS
DECLARE @ZYCS00 NUMERIC(2)  
DECLARE @LSH000  NUMERIC(10)
SELECT @ZYCS00=1
--更新住院次数
DECLARE CUR CURSOR FOR 
    SELECT LSH000 FROM BA_BRZYXX 
    WHERE  BAH000=@BAH000 AND BAZT00<>'2' ORDER BY BAH000,LSH000
OPEN CUR    
FETCH CUR INTO @LSH000
 WHILE (@@FETCH_STATUS=0) BEGIN
      UPDATE BA_BRZYXX SET ZYCS00=@ZYCS00
      WHERE LSH000=@LSH000
  SELECT @ZYCS00=@ZYCS00+1
  FETCH CUR INTO @LSH000
END
CLOSE CUR
DEALLOCATE CUR