Anasayfa
Giriş yap
tarafından - Kod:
[b][b][b][b][b][b][b][b]Object Stored Procedure dbo.RANK_KNIGHTS Script Date 662006 60332 PM
?? ?? ???? dbo.RANK_KNIGHTS ???? ?? 2002-11-14 ?? 111804
-- Created by sungyong 2002.10.14
Edit by webmsn
CREATE PROCEDURE RANK_KNIGHTS
AS
exec rank_knights
SET NOCOUNT ON
DECLARE @KnightsIndex smallint
DECLARE @SumLoyalty int
DECLARE job1 CURSOR FOR
SELECT IDNum FROM KNIGHTS
OPEN job1
FETCH NEXT FROM job1
INTO @KnightsIndex
WHILE @@fetch_status = 0
BEGIN
if @SumLoyalty is null
begin
SET @SumLoyalty = 0
end
SELECT @SumLoyalty=Sum(Loyalty) FROM USERDATA WHERE Knights = @KnightsIndex and City 255
IF @SumLoyalty 0
UPDATE KNIGHTS SET Points = @SumLoyalty WHERE IDNum = @KnightsIndex
FETCH NEXT FROM job1
INTO @KnightsIndex
END
CLOSE job1
DEALLOCATE job1
SET NOCOUNT OFF
-- ranking
UPDATE KNIGHTS SET Ranking=0 WHERE Ranking0
-- ranking procedure call
EXEC KNIGHTS_RATING_UPDATE
DECLARE @Knights_1 smallint
DECLARE @Knights_2 smallint
DECLARE @Knights_3 smallint
DECLARE @Knights_4 smallint
DECLARE @Knights_5 smallint
SELECT @Knights_1 = shIndex FROM KNIGHTS_RATING WHERE nRank=1
SELECT @Knights_2 = shIndex FROM KNIGHTS_RATING WHERE nRank=2
SELECT @Knights_3 = shIndex FROM KNIGHTS_RATING WHERE nRank=3
SELECT @Knights_4 = shIndex FROM KNIGHTS_RATING WHERE nRank=4
SELECT @Knights_5 = shIndex FROM KNIGHTS_RATING WHERE nRank=5
UPDATE KNIGHTS SET Ranking=1 WHERE IDNum=@Knights_1
UPDATE KNIGHTS SET Ranking=2 WHERE IDNum=@Knights_2
UPDATE KNIGHTS SET Ranking=3 WHERE IDNum=@Knights_3
UPDATE KNIGHTS SET Ranking=4 WHERE IDNum=@Knights_4
UPDATE KNIGHTS SET Ranking=5 WHERE IDNum=@Knights_5
GO[/b][/b][/b][/b][/b][/b][/b][/b]
2 posters
Oto Grade
NuLLMasTer99- Bronze Master
Mesaj Sayısı : 187 Kayıt tarihi : 14/05/09
MayoneZ- Gold Master
- Mesaj Sayısı : 2595 Kayıt tarihi : 06/05/09
Paylasım icin tesekkürler...