Grade Sistemi - İlk5:G0 - İlk5-10:G1 - İlk10-15:G2 - İlk15-20:G3

Merhaba Arkdaşlar;

Bu kodu Query Analyzr Yapıştırın.


HTML-Kodu:


CREATE PROCEDURE RANK_KNIGHTS2
AS
update knights set points = 790000 where ranking=1
update knights set points = 780000 where ranking=2
update knights set points = 770000 where ranking=3
update knights set points = 760000 where ranking=4
update knights set points = 750000 where ranking=5
update knights set points = 360000 where idname = (Select strname from KNIGHTS_RATING where nrank = 6)
update knights set points = 360000 where idname = (Select strname from KNIGHTS_RATING where nrank = 7)
update knights set points = 360000 where idname = (Select strname from KNIGHTS_RATING where nrank = 8)
update knights set points = 360000 where idname = (Select strname from KNIGHTS_RATING where nrank = 9)
update knights set points = 360000 where idname = (Select strname from KNIGHTS_RATING where nrank = 10)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 11)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 12)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 13)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 14)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 15)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 16)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 17)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 18)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 19)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 20)
update knights set points = 144000 where idname = (Select strname from KNIGHTS_RATING where nrank = 21)
GO



Bu KodLarı UyguLayınca Sisteminiz

• Ilk 5 G0
• Rank : 5 - 10 G1
• Rank : 10 - 15 G2
• Rank : 15 - 20 G3

OLUCAKTIR