Aşağıdaki örneği @CharID, @MasteryID ile çağırman halinde kılçıksız çalışması gerekiyor diye düşünüyorum.
DECLARE @LevelCap INT = 100
DECLARE @MasteryID INT = ?
-- Delete Corrupt Skills ~
DELETE [_CharSkill] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) ON [_CharSkill].[SkillID] = [_RefSkill].[ID] WHERE [_CharSkill].[CharID] = @CharID AND [_RefSkill].[ReqCommon_Mastery1] IN (SELECT [MasteryID] FROM [SRO_VT_SHARD].[dbo].[_CharSkillMastery] WITH(NOLOCK) WHERE [CharID] = @CharID AND [Level] < @LevelCap) AND [_CharSkill].[SkillID] NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625)
-- Delete Corrupt Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = 0 WHERE [CharID] = @CharID AND [Level] < @LevelCap
-- Add Mastery Skills ~
INSERT [SRO_VT_SHARD].[dbo].[_CharSkill] SELECT @CharID, [ID], 1 FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) WHERE [ID] IN...