Serverın En İyisini Belirlemek...

IF @Komut = 'Warrior'
BEGIN
SELECT @EmcWarrior = strUserID FROM USERDATA WHERE Class = 206 AND Race = 12 ORDER BY Loyalty Asc
print 'En Iyi Elmorad Erkek Warrior : ' + @EmcWarrior
SELECT @Barbar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 11 ORDER BY Loyalty Asc
print 'En iyi Elmorad Barbar Warrior : ' + @Barbar
SELECT @EmcFeMaleWar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Warrior : ' + @EmcFeMaleWar
SELECT @OrcWarrior = strUserID FROM USERDATA WHERE Class = 106 AND Race = 1 ORDER BY Loyalty Asc
print 'En Iyi Karus Barbar Warrior : ' + @OrcWarrior
RETURN
END
IF @Komut = 'Priest'
BEGIN
SELECT @EmcPriest = strUserID FROM USERDATA WHERE Class = 204 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Priest : ' + @EmcPriest
SELECT @EmcFeMalePri = strUserID FROM USERDATA WHERE Class = 204 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Priest : ' + @EmcFeMalePri
SELECT @OrcPriest = strUserID FROM USERDATA WHERE Class = 104 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Priest : ' + @OrcPriest
SELECT @OrcFeMalePri = strUserID FROM USERDATA WHERE CLass = 104 AND Race = 4 ORDER BY Loyalty Asc
print 'En iyi Karus Kadın Priest : ' + @OrcFeMalePri
RETURN
END
IF @Komut = 'Mage'
BEGIN
SELECT @EmcMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Mage : ' + @EmcMage
SELECT @EmcFeMaleMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Mage : ' + @EmcFeMaleMage
SELECT @OrcMage = strUserID FROM USERDATA WHERE Class = 110 AND Race = 3 ORDER BY Loyalty Asc
print 'En iyi Karus Wrinkle Mage : ' + @OrcMage
RETURN
END
IF @Komut = 'Rogue'
BEGIN
SELECT @EmcRogue = strUserID FROM USERDATA WHERE Class = 208 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Rogue : ' + @EmcRogue
SELECT @EmcFeMaleRog = strUserID FROM USERDATA WHERE Class = 208 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Rogue : ' + @EmcFeMaleRog
SELECT @OrcRogue = strUserID FROM USERDATA WHERE Class = 108 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Rogue : ' + @OrcRogue
RETURN
END
IF @Komut = 'Hepsi'
BEGIN
SELECT @EmcWarrior = strUserID FROM USERDATA WHERE Class = 206 AND Race = 12 ORDER BY Loyalty Asc
print 'En Iyi Elmorad Erkek Warrior : ' + @EmcWarrior
SELECT @Barbar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 11 ORDER BY Loyalty Asc
print 'En iyi Elmorad Barbar Warrior : ' + @Barbar
SELECT @EmcFeMaleWar = strUserID FROM USERDATA WHERE Class = 206 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Warrior : ' + @EmcFeMaleWar
SELECT @EmcPriest = strUserID FROM USERDATA WHERE Class = 204 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Priest : ' + @EmcPriest
SELECT @EmcFeMalePri = strUserID FROM USERDATA WHERE Class = 204 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Priest : ' + @EmcFeMalePri
SELECT @EmcMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Mage : ' + @EmcMage
SELECT @EmcFeMaleMage = strUserID FROM USERDATA WHERE Class = 210 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Mage : ' + @EmcFeMaleMage
SELECT @EmcRogue = strUserID FROM USERDATA WHERE Class = 208 AND Race = 12 ORDER BY Loyalty Asc
print 'En iyi Elmorad Erkek Rogue : ' + @EmcRogue
SELECT @EmcFeMaleRog = strUserID FROM USERDATA WHERE Class = 208 AND Race = 13 ORDER BY Loyalty Asc
print 'En iyi Elmorad Kadın Rogue : ' + @EmcFeMaleRog
SELECT @OrcWarrior = strUserID FROM USERDATA WHERE Class = 106 AND Race = 1 ORDER BY Loyalty Asc
print 'En Iyi Karus Barbar Warrior : ' + @OrcWarrior
SELECT @OrcPriest = strUserID FROM USERDATA WHERE Class = 104 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Priest : ' + @OrcPriest
SELECT @OrcFeMalePri = strUserID FROM USERDATA WHERE CLass = 104 AND Race = 4 ORDER BY Loyalty Asc
print 'En iyi Karus Kadın Priest : ' + @OrcFeMalePri
SELECT @OrcMage = strUserID FROM USERDATA WHERE Class = 110 AND Race = 3 ORDER BY Loyalty Asc
print 'En iyi Karus Wrinkle Mage : ' + @OrcMage
SELECT @OrcRogue = strUserID FROM USERDATA WHERE Class = 108 AND Race = 2 ORDER BY Loyalty Asc
print 'En iyi Karus Erkek Rogue : ' + @OrcRogue
RETURN
END
GO