%100 symbol 50 karali 50 karesiz Burak Yapım

tarafından tr-powerko Çarş. Mayıs 12, 2010 4:16 pm

Kod:: CREATE PROCEDURE Power AS --_lm4Power_ ' e Yazılmıştır. --09/05/2008 13.09 declare @KNP int, @HNP int select @KNP = nKarusLoyalty from user_knights_rank where shindex = 6 select @HNP = nElmoLoyalty from user_knights_rank where shindex = 6 truncate table npkarus insert npkarus select top 100 strUserID, Loyalty, LoyaltyMonthly from USERDATA where Nation = 1 and Loyalty < @KNP order by Loyalty desc, LoyaltyMonthly desc truncate table nphuman insert nphuman select top 100 strUserID, Loyalty, LoyaltyMonthly from USERDATA where Nation = 2 and Loyalty < @HNP order by Loyalty desc, LoyaltyMonthly desc declare @Karusa varchar(21), @Karusb varchar(21), @Karusc varchar(21), @Karusd varchar(21), @Karuse varchar(21), @Karusf varchar(21), @Karusg varchar(21), @Karush varchar(21), @Karusi varchar(21), @Karusj varchar(21), @Karusk varchar(21), @Karusl varchar(21), @Karusm varchar(21), @Karusn varchar(21), @Karusu varchar(21), @Karusv varchar(21), @Karusy varchar(21), @Karusx varchar(21), @Karusw varchar(21), @Karusz varchar(21), @Karusab varchar(21), @Karusac varchar(21), @Karusad varchar(21), @Karusae varchar(21), @Karusaf varchar(21), @Karusag varchar(21), @Karusah varchar(21), @Karusai varchar(21), @Karusaj varchar(21), @Karusak varchar(21), @Karusaka varchar(21), @Karusakb varchar(21), @Karusakc varchar(21), @Karusakd varchar(21), @Karusake varchar(21), @Karusakf varchar(21), @Karusakg varchar(21), @Karusakh varchar(21), @Karusaki varchar(21), @Karusakj varchar(21), @Karusakk varchar(21), @Karusakl varchar(21), @Karusakm varchar(21), @Karusakn varchar(21), @Karusako varchar(21), @Karusakp varchar(21), @Karusakr varchar(21), @Karusaks varchar(21), @Karusakt varchar(21), @Karusaku varchar(21), @Karusakv varchar(21), @Karusaky varchar(21), @Karusakz varchar(21), @Karusakx varchar(21), @Karusakq varchar(21), @Karusakw varchar(21), @Karusza varchar(21), @Karuszb varchar(21), @Karuszc varchar(21), @Karuszd varchar(21), @Karusze varchar(21), @Karuszf varchar(21), @Karuszg varchar(21), @Karuszh varchar(21), @Karuszi varchar(21), @Karuszj varchar(21), @Karuszk varchar(21), @Karuszl varchar(21), @Karuszm varchar(21), @Karuszn varchar(21), @Karuszo varchar(21), @Karuszp varchar(21), @Karuszr varchar(21), @Karuszs varchar(21), @Karuszt varchar(21), @Karuszu varchar(21), @Karuszv varchar(21), @Karuszy varchar(21), @Karuszz varchar(21), @Karuszq varchar(21), @Karuszw varchar(21), @Karuszx varchar(21), @Karuszca varchar(21), @Karuszcb varchar(21), @Karuszcc varchar(21), @Karuszcd varchar(21), @Karuszce varchar(21), @Karuszcf varchar(21), @Karuszcg varchar(21), @Karuszch varchar(21), @Karuszci varchar(21), @Karuszcj varchar(21), @Karuszck varchar(21), @Karuszcl varchar(21), @Karuszcm varchar(21), @Karuszcn varchar(21), @Karuszco varchar(21), @Karuszcp varchar(21), @Karuszcr varchar(21), @Karuszcs varchar(21), @Elmoa varchar(21), @Elmob varchar(21), @Elmoc varchar(21), @Elmod varchar(21), @Elmoe varchar(21), @Elmof varchar(21), @Elmog varchar(21), @Elmoh varchar(21), @Elmoi varchar(21), @Elmoj varchar(21), @Elmok varchar(21), @Elmol varchar(21), @Elmom varchar(21), @Elmon varchar(21), @Elmou varchar(21), @Elmov varchar(21), @Elmoy varchar(21), @Elmox varchar(21), @Elmow varchar(21), @Elmoz varchar(21), @Elmoab varchar(21), @Elmoac varchar(21), @Elmoad varchar(21), @Elmoae varchar(21), @Elmoaf varchar(21), @Elmoag varchar(21), @Elmoah varchar(21), @Elmoai varchar(21), @Elmoaj varchar(21), @Elmoak varchar(21), @Elmoaka varchar(21), @Elmoakb varchar(21), @Elmoakc varchar(21), @Elmoakd varchar(21), @Elmoake varchar(21), @Elmoakf varchar(21), @Elmoakg varchar(21), @Elmoakh varchar(21), @Elmoaki varchar(21), @Elmoakj varchar(21), @Elmoakk varchar(21), @Elmoakl varchar(21), @Elmoakm varchar(21), @Elmoakn varchar(21), @Elmoako varchar(21), @Elmoakp varchar(21), @Elmoakr varchar(21), @Elmoaks varchar(21), @Elmoakt varchar(21), @Elmoaku varchar(21), @Elmoakv varchar(21), @Elmoaky varchar(21), @Elmoakz varchar(21), @Elmoakq varchar(21), @Elmoakw varchar(21), @Elmoakx varchar(21), @Elmoza varchar(21), @Elmozb varchar(21), @Elmozc varchar(21), @Elmozd varchar(21), @Elmoze varchar(21), @Elmozf varchar(21), @Elmozg varchar(21), @Elmozh varchar(21), @Elmozi varchar(21), @Elmozj varchar(21), @Elmozk varchar(21), @Elmozl varchar(21), @Elmozm varchar(21), @Elmozn varchar(21), @Elmozo varchar(21), @Elmozp varchar(21), @Elmozr varchar(21), @Elmozs varchar(21), @Elmozt varchar(21), @Elmozu varchar(21), @Elmozv varchar(21), @Elmozy varchar(21), @Elmozz varchar(21), @Elmozq varchar(21), @Elmozw varchar(21), @Elmozx varchar(21), @Elmozca varchar(21), @Elmozcb varchar(21), @Elmozcc varchar(21), @Elmozcd varchar(21), @Elmozce varchar(21), @Elmozcf varchar(21), @Elmozcg varchar(21), @Elmozch varchar(21), @Elmozci varchar(21), @Elmozcj varchar(21), @Elmozck varchar(21), @Elmozcl varchar(21), @Elmozcm varchar(21), @Elmozcn varchar(21), @Elmozco varchar(21), @Elmozcp varchar(21), @Elmozcr varchar(21), @Elmozcs varchar(21) select @Karusa = strUserID from npkarus where nRank = 1 select @Karusb = strUserID from npkarus where nRank = 2 select @Karusc = strUserID from npkarus where nRank = 3 select @Karusd = strUserID from npkarus where nRank = 4 select @Karuse = strUserID from npkarus where nRank = 5 select @Karusf = strUserID from npkarus where nRank = 6 select @Karusg = strUserID from npkarus where nRank = 7 select @Karush = strUserID from npkarus where nRank = 8 select @Karusi = strUserID from npkarus where nRank = 9 select @Karusj = strUserID from npkarus where nRank = 10 select @Karusk = strUserID from npkarus where nRank = 11 select @Karusl = strUserID from npkarus where nRank = 12 select @Karusm = strUserID from npkarus where nRank = 13 select @Karusn = strUserID from npkarus where nRank = 14 select @Karusu = strUserID from npkarus where nRank = 15 select @Karusv = strUserID from npkarus where nRank = 16 select @Karusy = strUserID from npkarus where nRank = 17 select @Karusx = strUserID from npkarus where nRank = 18 select @Karusw = strUserID from npkarus where nRank = 19 select @Karusz = strUserID from npkarus where nRank = 20 select @Karusab = strUserID from npkarus where nRank = 21 select @Karusac = strUserID from npkarus where nRank = 22 select @Karusad = strUserID from npkarus where nRank = 23 select @Karusae = strUserID from npkarus where nRank = 24 select @Karusaf = strUserID from npkarus where nRank = 25 select @Karusag = strUserID from npkarus where nRank = 26 select @Karusah = strUserID from npkarus where nRank = 27 select @Karusai = strUserID from npkarus where nRank = 28 select @Karusaj = strUserID from npkarus where nRank = 29 select @Karusak = strUserID from npkarus where nRank = 30 select @Karusaka = strUserID from npkarus where nRank = 31 select @Karusakb = strUserID from npkarus where nRank = 32 select @Karusakc = strUserID from npkarus where nRank = 33 select @Karusakd = strUserID from npkarus where nRank = 34 select @Karusake = strUserID from npkarus where nRank = 35 select @Karusakf = strUserID from npkarus where nRank = 36 select @Karusakg = strUserID from npkarus where nRank = 37 select @Karusakh = strUserID from npkarus where nRank = 38 select @Karusaki = strUserID from npkarus where nRank = 39 select @Karusakj = strUserID from npkarus where nRank = 40 select @Karusakk = strUserID from npkarus where nRank = 41 select @Karusakl = strUserID from npkarus where nRank = 42 select @Karusakm = strUserID from npkarus where nRank = 43 select @Karusakn = strUserID from npkarus where nRank = 44 select @Karusako = strUserID from npkarus where nRank = 45 select @Karusakp = strUserID from npkarus where nRank = 46 select @Karusakr = strUserID from npkarus where nRank = 47 select @Karusaks = strUserID from npkarus where nRank = 48 select @Karusakt = strUserID from npkarus where nRank = 49 select @Karusaku = strUserID from npkarus where nRank = 50 select @Karusakv = strUserID from npkarus where nRank = 51 select @Karusaky = strUserID from npkarus where nRank = 52 select @Karusakz = strUserID from npkarus where nRank = 53 select @Karusakx = strUserID from npkarus where nRank = 54 select @Karusakq = strUserID from npkarus where nRank = 55 select @Karusakw = strUserID from npkarus where nRank = 56 select @Karusza = strUserID from npkarus where nRank = 57 select @Karuszb = strUserID from npkarus where nRank = 58 select @Karuszc = strUserID from npkarus where nRank = 59 select @Karuszd = strUserID from npkarus where nRank = 60 select @Karusze = strUserID from npkarus where nRank = 61 select @Karuszf = strUserID from npkarus where nRank = 62 select @Karuszg = strUserID from npkarus where nRank = 63 select @Karuszh = strUserID from npkarus where nRank = 64 select @Karuszi = strUserID from npkarus where nRank = 65 select @Karuszj = strUserID from npkarus where nRank = 66 select @Karuszk = strUserID from npkarus where nRank = 67 select @Karuszl = strUserID from npkarus where nRank = 68 select @Karuszm = strUserID from npkarus where nRank = 69 select @Karuszn = strUserID from npkarus where nRank = 70 select @Karuszo = strUserID from npkarus where nRank = 71 select @Karuszp = strUserID from npkarus where nRank = 72 select @Karuszr = strUserID from npkarus where nRank = 73 select @Karuszs = strUserID from npkarus where nRank = 74 select @Karuszt = strUserID from npkarus where nRank = 75 select @Karuszu = strUserID from npkarus where nRank = 76 select @Karuszv = strUserID from npkarus where nRank = 77 select @Karuszy = strUserID from npkarus where nRank = 78 select @Karuszz = strUserID from npkarus where nRank = 79 select @Karuszq = strUserID from npkarus where nRank = 80 select @Karuszw = strUserID from npkarus where nRank = 81 select @Karuszx = strUserID from npkarus where nRank = 82 select @Karuszca = strUserID from npkarus where nRank = 83 select @Karuszcb = strUserID from npkarus where nRank = 84 select @Karuszcc = strUserID from npkarus where nRank = 85 select @Karuszcd = strUserID from npkarus where nRank = 86 select @Karuszce = strUserID from npkarus where nRank = 87 select @Karuszcf = strUserID from npkarus where nRank = 88 select @Karuszcg = strUserID from npkarus where nRank = 89 select @Karuszch = strUserID from npkarus where nRank = 90 select @Karuszci = strUserID from npkarus where nRank = 91 select @Karuszcj = strUserID from npkarus where nRank = 92 select @Karuszck = strUserID from npkarus where nRank = 93 select @Karuszcl = strUserID from npkarus where nRank = 94 select @Karuszcm = strUserID from npkarus where nRank = 95 select @Karuszcn = strUserID from npkarus where nRank = 96 select @Karuszco = strUserID from npkarus where nRank = 97 select @Karuszcp = strUserID from npkarus where nRank = 98 select @Karuszcr = strUserID from npkarus where nRank = 99 select @Karuszcs = strUserID from npkarus where nRank = 100 select @Elmoa = strUserID from nphuman where nRank = 1 select @Elmob = strUserID from nphuman where nRank = 2 select @Elmoc = strUserID from nphuman where nRank = 3 select @Elmod = strUserID from nphuman where nRank = 4 select @Elmoe = strUserID from nphuman where nRank = 5 select @Elmof = strUserID from nphuman where nRank = 6 select @Elmog = strUserID from nphuman where nRank = 7 select @Elmoh = strUserID from nphuman where nRank = 8 select @Elmoi = strUserID from nphuman where nRank = 9 select @Elmoj = strUserID from nphuman where nRank = 10 select @Elmok = strUserID from nphuman where nRank = 11 select @Elmol = strUserID from nphuman where nRank = 12 select @Elmom = strUserID from nphuman where nRank = 13 select @Elmon = strUserID from nphuman where nRank = 14 select @Elmou = strUserID from nphuman where nRank = 15 select @Elmov = strUserID from nphuman where nRank = 16 select @Elmoy = strUserID from nphuman where nRank = 17 select @Elmox = strUserID from nphuman where nRank = 18 select @Elmow = strUserID from nphuman where nRank = 19 select @Elmoz = strUserID from nphuman where nRank = 20 select @Elmoab = strUserID from nphuman where nRank = 21 select @Elmoac = strUserID from nphuman where nRank = 22 select @Elmoad = strUserID from nphuman where nRank = 23 select @Elmoae = strUserID from nphuman where nRank = 24 select @Elmoaf = strUserID from nphuman where nRank = 25 select @Elmoag = strUserID from nphuman where nRank = 26 select @Elmoah = strUserID from nphuman where nRank = 27 select @Elmoai = strUserID from nphuman where nRank = 28 select @Elmoaj = strUserID from nphuman where nRank = 29 select @Elmoak = strUserID from nphuman where nRank = 30 select @Elmoaka = strUserID from nphuman where nRank = 31 select @Elmoakb = strUserID from nphuman where nRank = 32 select @Elmoakc = strUserID from nphuman where nRank = 33 select @Elmoakd = strUserID from nphuman where nRank = 34 select @Elmoake = strUserID from nphuman where nRank = 35 select @Elmoakf = strUserID from nphuman where nRank = 36 select @Elmoakg = strUserID from nphuman where nRank = 37 select @Elmoakh = strUserID from nphuman where nRank = 38 select @Elmoaki = strUserID from nphuman where nRank = 39 select @Elmoakj = strUserID from nphuman where nRank = 40 select @Elmoakk = strUserID from nphuman where nRank = 41 select @Elmoakl = strUserID from nphuman where nRank = 42 select @Elmoakm = strUserID from nphuman where nRank = 43 select @Elmoakn = strUserID from nphuman where nRank = 44 select @Elmoako = strUserID from nphuman where nRank = 45 select @Elmoakp = strUserID from nphuman where nRank = 46 select @Elmoakr = strUserID from nphuman where nRank = 47 select @Elmoaks = strUserID from nphuman where nRank = 48 select @Elmoakt = strUserID from nphuman where nRank = 49 select @Elmoaku = strUserID from nphuman where nRank = 50 select @Elmoakv = strUserID from nphuman where nRank = 51 select @Elmoaky = strUserID from nphuman where nRank = 52 select @Elmoakz = strUserID from nphuman where nRank = 53 select @Elmoakx = strUserID from nphuman where nRank = 54 select @Elmoakq = strUserID from nphuman where nRank = 55 select @Elmoakw = strUserID from nphuman where nRank = 56 select @Elmoza = strUserID from nphuman where nRank = 57 select @Elmozb = strUserID from nphuman where nRank = 58 select @Elmozc = strUserID from nphuman where nRank = 59 select @Elmozd = strUserID from nphuman where nRank = 60 select @Elmoze = strUserID from nphuman where nRank = 61 select @Elmozf = strUserID from nphuman where nRank = 62 select @Elmozg = strUserID from nphuman where nRank = 63 select @Elmozh = strUserID from nphuman where nRank = 64 select @Elmozi = strUserID from nphuman where nRank = 65 select @Elmozj = strUserID from nphuman where nRank = 66 select @Elmozk = strUserID from nphuman where nRank = 67 select @Elmozl = strUserID from nphuman where nRank = 68 select @Elmozm = strUserID from nphuman where nRank = 69 select @Elmozn = strUserID from nphuman where nRank = 70 select @Elmozo = strUserID from nphuman where nRank = 71 select @Elmozp = strUserID from nphuman where nRank = 72 select @Elmozr = strUserID from nphuman where nRank = 73 select @Elmozs = strUserID from nphuman where nRank = 74 select @Elmozt = strUserID from nphuman where nRank = 75 select @Elmozu = strUserID from nphuman where nRank = 76 select @Elmozv = strUserID from nphuman where nRank = 77 select @Elmozy = strUserID from nphuman where nRank = 78 select @Elmozz = strUserID from nphuman where nRank = 79 select @Elmozq = strUserID from nphuman where nRank = 80 select @Elmozw = strUserID from nphuman where nRank = 81 select @Elmozx = strUserID from nphuman where nRank = 82 select @Elmozca = strUserID from nphuman where nRank = 83 select @Elmozcb = strUserID from nphuman where nRank = 84 select @Elmozcc = strUserID from nphuman where nRank = 85 select @Elmozcd = strUserID from nphuman where nRank = 86 select @Elmozce = strUserID from nphuman where nRank = 87 select @Elmozcf = strUserID from nphuman where nRank = 88 select @Elmozcg = strUserID from nphuman where nRank = 89 select @Elmozch = strUserID from nphuman where nRank = 90 select @Elmozci = strUserID from nphuman where nRank = 91 select @Elmozcj = strUserID from nphuman where nRank = 92 select @Elmozck = strUserID from nphuman where nRank = 93 select @Elmozcl = strUserID from nphuman where nRank = 94 select @Elmozcm = strUserID from nphuman where nRank = 95 select @Elmozcn = strUserID from nphuman where nRank = 96 select @Elmozco = strUserID from nphuman where nRank = 97 select @Elmozcp = strUserID from nphuman where nRank = 98 select @Elmozcr = strUserID from nphuman where nRank = 99 select @Elmozcs = strUserID from nphuman where nRank = 100 /* Update */ update user_personal_rank set strElmoUserID = @Elmoa, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoa), strKarusUserID = @karusa, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusa) where nRank = 1 update user_personal_rank set strElmoUserID = @Elmob, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmob), strKarusUserID = @karusb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusb) where nRank = 2 update user_personal_rank set strElmoUserID = @Elmoc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoc), strKarusUserID = @karusc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusc) where nRank = 3 update user_personal_rank set strElmoUserID = @Elmod, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmod), strKarusUserID = @karusd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusd) where nRank = 4 update user_personal_rank set strElmoUserID = @Elmoe, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoe), strKarusUserID = @karuse, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuse) where nRank = 5 update user_personal_rank set strElmoUserID = @Elmof, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmof), strKarusUserID = @karusf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusf) where nRank = 6 update user_personal_rank set strElmoUserID = @Elmog, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmog), strKarusUserID = @karusg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusg) where nRank = 7 update user_personal_rank set strElmoUserID = @Elmoh, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoh), strKarusUserID = @karush, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karush) where nRank = 8 update user_personal_rank set strElmoUserID = @Elmoi, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoi), strKarusUserID = @karusi, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusi) where nRank = 9 update user_personal_rank set strElmoUserID = @Elmoj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoj), strKarusUserID = @karusj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusj) where nRank = 10 update user_personal_rank set strElmoUserID = @Elmok, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmok), strKarusUserID = @karusk, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusk) where nRank = 11 update user_personal_rank set strElmoUserID = @Elmol, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmol), strKarusUserID = @karusl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusl) where nRank = 12 update user_personal_rank set strElmoUserID = @Elmom, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmom), strKarusUserID = @karusm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusm) where nRank = 13 update user_personal_rank set strElmoUserID = @Elmon, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmon), strKarusUserID = @karusn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusn) where nRank = 14 update user_personal_rank set strElmoUserID = @Elmou, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmou), strKarusUserID = @karusu, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusu) where nRank = 15 update user_personal_rank set strElmoUserID = @Elmov, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmov), strKarusUserID = @karusv, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusv) where nRank = 16 update user_personal_rank set strElmoUserID = @Elmoy, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoy), strKarusUserID = @karusy, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusy) where nRank = 17 update user_personal_rank set strElmoUserID = @Elmox, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmox), strKarusUserID = @karusx, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusx) where nRank = 18 update user_personal_rank set strElmoUserID = @Elmow, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmow), strKarusUserID = @karusw, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusw) where nRank = 19 update user_personal_rank set strElmoUserID = @Elmoz, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoz), strKarusUserID = @karusz, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusz) where nRank = 20 update user_personal_rank set strElmoUserID = @Elmoab, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoab), strKarusUserID = @karusab, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusab) where nRank = 21 update user_personal_rank set strElmoUserID = @Elmoac, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoac), strKarusUserID = @karusac, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusac) where nRank = 22 update user_personal_rank set strElmoUserID = @Elmoad, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoad), strKarusUserID = @karusad, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusad) where nRank = 23 update user_personal_rank set strElmoUserID = @Elmoae, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoae), strKarusUserID = @karusae, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusae) where nRank = 24 update user_personal_rank set strElmoUserID = @Elmoaf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaf), strKarusUserID = @karusaf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaf) where nRank = 25 update user_personal_rank set strElmoUserID = @Elmoag, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoag), strKarusUserID = @karusag, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusag) where nRank = 26 update user_personal_rank set strElmoUserID = @Elmoah, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoah), strKarusUserID = @karusah, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusah) where nRank = 27 update user_personal_rank set strElmoUserID = @Elmoai, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoai), strKarusUserID = @karusai, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusai) where nRank = 28 update user_personal_rank set strElmoUserID = @Elmoaj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaj), strKarusUserID = @karusaj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaj) where nRank = 29 update user_personal_rank set strElmoUserID = @Elmoak, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoak), strKarusUserID = @karusak, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusak) where nRank = 30 update user_personal_rank set strElmoUserID = @Elmoaka, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaka), strKarusUserID = @karusaka, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaka) where nRank = 31 update user_personal_rank set strElmoUserID = @Elmoakb, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakb), strKarusUserID = @karusakb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakb) where nRank = 32 update user_personal_rank set strElmoUserID = @Elmoakc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakc), strKarusUserID = @karusakc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakc) where nRank = 33 update user_personal_rank set strElmoUserID = @Elmoakd, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakd), strKarusUserID = @karusakd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakd) where nRank = 34 update user_personal_rank set strElmoUserID = @Elmoake, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoake), strKarusUserID = @karusake, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusake) where nRank = 35 update user_personal_rank set strElmoUserID = @Elmoakf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakf), strKarusUserID = @karusakf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakf) where nRank = 36 update user_personal_rank set strElmoUserID = @Elmoakg, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakg), strKarusUserID = @karusakg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakg) where nRank = 37 update user_personal_rank set strElmoUserID = @Elmoakh, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakh), strKarusUserID = @karusakh, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakh) where nRank = 38 update user_personal_rank set strElmoUserID = @Elmoaki, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaki), strKarusUserID = @karusaki, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaki) where nRank = 39 update user_personal_rank set strElmoUserID = @Elmoakj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakj), strKarusUserID = @karusakj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakj) where nRank = 40 update user_personal_rank set strElmoUserID = @Elmoakk, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakk), strKarusUserID = @karusakk, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakk) where nRank = 41 update user_personal_rank set strElmoUserID = @Elmoakl, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakl), strKarusUserID = @karusakl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakl) where nRank = 42 update user_personal_rank set strElmoUserID = @Elmoakm, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakm), strKarusUserID = @karusakm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakm) where nRank = 43 update user_personal_rank set strElmoUserID = @Elmoakn, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakn), strKarusUserID = @karusakn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakn) where nRank = 44 update user_personal_rank set strElmoUserID = @Elmoako, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoako), strKarusUserID = @karusako, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusako) where nRank = 45 update user_personal_rank set strElmoUserID = @Elmoakp, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakp), strKarusUserID = @karusakp, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakp) where nRank = 46 update user_personal_rank set strElmoUserID = @Elmoakr, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakr), strKarusUserID = @karusakr, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakr) where nRank = 47 update user_personal_rank set strElmoUserID = @Elmoaks, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaks), strKarusUserID = @karusaks, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaks) where nRank = 48 update user_personal_rank set strElmoUserID = @Elmoakt, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakt), strKarusUserID = @karusakt, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakt) where nRank = 49 update user_personal_rank set strElmoUserID = @Elmoaku, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaku), strKarusUserID = @karusaku, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaku) where nRank = 50 update user_personal_rank set strElmoUserID = @Elmoakv, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakv), strKarusUserID = @karusakv, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakv) where nRank = 51 update user_personal_rank set strElmoUserID = @Elmoaky, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaky), strKarusUserID = @karusaky, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaky) where nRank = 52 update user_personal_rank set strElmoUserID = @Elmoakz, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakz), strKarusUserID = @karusakz, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakz) where nRank = 53 update user_personal_rank set strElmoUserID = @Elmoakx, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakx), strKarusUserID = @karusakx, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakx) where nRank = 54 update user_personal_rank set strElmoUserID = @Elmoakq, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakq), strKarusUserID = @karusakq, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakq) where nRank = 55 update user_personal_rank set strElmoUserID = @Elmoakw, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoakw), strKarusUserID = @karusakw, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusakw) where nRank = 56 update user_personal_rank set strElmoUserID = @Elmoza, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoza), strKarusUserID = @karusza, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusza) where nRank = 57 update user_personal_rank set strElmoUserID = @Elmozb, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozb), strKarusUserID = @karuszb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszb) where nRank = 58 update user_personal_rank set strElmoUserID = @Elmozc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozc), strKarusUserID = @karuszc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszc) where nRank = 59 update user_personal_rank set strElmoUserID = @Elmozd, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozd), strKarusUserID = @karuszd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszd) where nRank = 60 update user_personal_rank set strElmoUserID = @Elmoze, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoze), strKarusUserID = @karusze, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusze) where nRank = 61 update user_personal_rank set strElmoUserID = @Elmozf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozf), strKarusUserID = @karuszf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszf) where nRank = 62 update user_personal_rank set strElmoUserID = @Elmozg, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozg), strKarusUserID = @karuszg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszg) where nRank = 63 update user_personal_rank set strElmoUserID = @Elmozh, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozh), strKarusUserID = @karuszh, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszh) where nRank = 64 update user_personal_rank set strElmoUserID = @Elmozi, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozi), strKarusUserID = @karuszi, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszi) where nRank = 65 update user_personal_rank set strElmoUserID = @Elmozj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozj), strKarusUserID = @karuszj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszj) where nRank = 66 update user_personal_rank set strElmoUserID = @Elmozk, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozk), strKarusUserID = @karuszk, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszk) where nRank = 67 update user_personal_rank set strElmoUserID = @Elmozl, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozl), strKarusUserID = @karuszl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszl) where nRank = 68 update user_personal_rank set strElmoUserID = @Elmozm, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozm), strKarusUserID = @karuszm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszm) where nRank = 69 update user_personal_rank set strElmoUserID = @Elmozn, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozn), strKarusUserID = @karuszn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszn) where nRank = 70 update user_personal_rank set strElmoUserID = @Elmozo, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozo), strKarusUserID = @karuszo, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszo) where nRank = 71 update user_personal_rank set strElmoUserID = @Elmozp, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozp), strKarusUserID = @karuszp, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszp) where nRank = 72 update user_personal_rank set strElmoUserID = @Elmozr, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozr), strKarusUserID = @karuszr, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszr) where nRank = 73 update user_personal_rank set strElmoUserID = @Elmozs, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozs), strKarusUserID = @karuszs, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszs) where nRank = 74 update user_personal_rank set strElmoUserID = @Elmozt, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozt), strKarusUserID = @karuszt, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszt) where nRank = 75 update user_personal_rank set strElmoUserID = @Elmozu, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozu), strKarusUserID = @karuszu, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszu) where nRank = 76 update user_personal_rank set strElmoUserID = @Elmozv, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozv), strKarusUserID = @karuszv, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszv) where nRank = 77 update user_personal_rank set strElmoUserID = @Elmozy, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozy), strKarusUserID = @karuszy, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszy) where nRank = 78 update user_personal_rank set strElmoUserID = @Elmozz, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozz), strKarusUserID = @karuszz, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszz) where nRank = 79 update user_personal_rank set strElmoUserID = @Elmozq, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozq), strKarusUserID = @karuszq, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszq) where nRank = 80 update user_personal_rank set strElmoUserID = @Elmozw, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozw), strKarusUserID = @karuszw, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszw) where nRank = 81 update user_personal_rank set strElmoUserID = @Elmozx, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozx), strKarusUserID = @karuszx, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszx) where nRank = 82 update user_personal_rank set strElmoUserID = @Elmozca, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozca), strKarusUserID = @karuszca, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszca) where nRank = 83 update user_personal_rank set strElmoUserID = @Elmozcb, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcb), strKarusUserID = @karuszcb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcb) where nRank = 84 update user_personal_rank set strElmoUserID = @Elmozcc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcc), strKarusUserID = @karuszcc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcc) where nRank = 85 update user_personal_rank set strElmoUserID = @Elmozcd, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcd), strKarusUserID = @karuszcd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcd) where nRank = 86 update user_personal_rank set strElmoUserID = @Elmozce, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozce), strKarusUserID = @karuszce, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszce) where nRank = 87 update user_personal_rank set strElmoUserID = @Elmozcf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcf), strKarusUserID = @karuszcf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcf) where nRank = 88 update user_personal_rank set strElmoUserID = @Elmozcg, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcg), strKarusUserID = @karuszcg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcg) where nRank = 89 update user_personal_rank set strElmoUserID = @Elmozch, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozch), strKarusUserID = @karuszch, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszch) where nRank = 90 update user_personal_rank set strElmoUserID = @Elmozci, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozci), strKarusUserID = @karuszci, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszci) where nRank = 91 update user_personal_rank set strElmoUserID = @Elmozcj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcj), strKarusUserID = @karuszcj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcj) where nRank = 92 update user_personal_rank set strElmoUserID = @Elmozck, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozck), strKarusUserID = @karuszck, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszck) where nRank = 93 update user_personal_rank set strElmoUserID = @Elmozcl, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcl), strKarusUserID = @karuszcl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcl) where nRank = 94 update user_personal_rank set strElmoUserID = @Elmozcm, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcm), strKarusUserID = @karuszcm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcm) where nRank = 95 update user_personal_rank set strElmoUserID = @Elmozcn, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcn), strKarusUserID = @karuszcn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcn) where nRank = 96 update user_personal_rank set strElmoUserID = @Elmozco, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozco), strKarusUserID = @karuszco, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszco) where nRank = 97 update user_personal_rank set strElmoUserID = @Elmozcp, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcp), strKarusUserID = @karuszcp, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcp) where nRank = 98 update user_personal_rank set strElmoUserID = @Elmozcr, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcr), strKarusUserID = @karuszcr, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcr) where nRank = 99 update user_personal_rank set strElmoUserID = @Elmozcs, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmozcs), strKarusUserID = @karuszcs, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuszcs) where nRank = 100 GO Çalışması için gerekli kod exec Power