[Paylaşım] ilk 5 clanı g0 Dierlerini g1 yapmak Sorunsuz

CREATE PROCEDURE ilk5g0 AS--Bu Proc OsmaN Tarafından Yazılmıştır--exec
rank_knightsupdate knights set points = '999999',ranking = '0'update
knights set points = '999999',ranking = '1'where idname = (Select
strname from KNIGHTS_RATING where nrank = 1)update knights set points =
'999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING
 where nrank = 2)update knights set points = '999999',ranking = '1'where
 idname = (Select strname from KNIGHTS_RATING where nrank = 3)update
knights set points = '999999',ranking = '1'where idname = (Select
strname from KNIGHTS_RATING where nrank = 4)update knights set points =
'999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING
 where nrank = 5)GO