Admin Admin
Mesaj Sayısı : 51 Nerden : Kayseri İş/Hobiler : İnternet Lakap : NightMare Kayıt tarihi : 17/01/09
| Konu: Query Analyzer Oto Grade Paz Şub. 01, 2009 11:21 pm | |
| Query Analyzer Oto grade kod'u... - Kod:
-
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 GOOto Master | |
|