مشكلة في Procedure لـSkill Scroll

[iRock]

USE [SRO_VT_LOG]
---- Warrior Skills Scroll 
----------------------------------
   Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int
   Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
   Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0)
  IF (@ItemRefID = 41806) 
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1
		 END
		 END
		 END
		 END
---- Dagger Skills Scroll 
----------------------------------
		  IF (@ItemRefID = 41807) 
       Begin
		 IF @CharObjID > 3000
		 Begin
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1
		 END
		 END
		 END
		 END
---- Wizard Skills Scroll 
----------------------------------
      IF (@ItemRefID = 41805) 
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1
		 End 
		 END
		 END
       End
---- Warlock Skills Scroll 
----------------------------------
      IF (@ItemRefID = 41810)
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1
		 End 
		 END
		 End
       End

 -- Bard Skills Scroll 
-------------------------------
      IF (@ItemRefID = 41809) 
       Begin
		 IF @CharObjID > 3000
		 Begin
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1
		 End 
		 END
		 End
       End

  -- Claric Skills Scroll 
---------------------------------
      IF (@ItemRefID = 41808) 
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1
		 End 
		 End
         End
		 END
 ---- Bicheon Skills Scroll 
----------------------------------
      IF (@ItemRefID = 41800) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1
		 End 
		 END
		 End
       End

 ---- Heuksal Skills Scroll
----------------------------------
      IF (@ItemRefID = 41799) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1
		 End 
		 END
		 END
       End

 ---- Pacheon Skills Scroll
----------------------------------
      IF (@ItemRefID = 41798) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1
		 End 
		 END
		 End
       End

 ---- Cold Skills Scroll 
-------------------------------
      IF (@ItemRefID = 41803) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1
		 End 
		 End
		 End
       End

 ---- Lightning Skills Scroll 
-------------------------------------
      IF (@ItemRefID = 41802) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1
		 End 
		 End
		 End
       End

 ---- Fire Skills Scroll 
--------------------------------
      IF (@ItemRefID = 41801) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1
		 End 
		 End
		 End
       End

 ---- Force Skills Scroll 
---------------------------------
      IF (@ItemRefID = 41804) -- RefObjCommon ID
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1
		 End 
		 End
       End
	   END

Error

Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 16
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 18
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 25
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 34
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 36
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 43
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 50
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 52
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 53
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 54
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 61
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 68
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 70
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 71
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 72
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 80
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 87
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 89
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 90
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 99
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 106
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 108
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 109
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 110
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 117
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 124
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 126
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 127
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 128
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 136
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 143
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 145
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 146
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 147
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 155
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 162
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 164
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 165
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 166
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 174
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 181
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 183
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 184
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 185
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 193
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 200
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 202
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 203
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 204
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 212
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 219
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 221
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 222
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 223
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 231
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 238
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 240
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 241
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 242
Must declare the scalar variable "@CharID".

انا بستخدم SQL Server 2008 R2 Express

يا ريت لو حد يقولي ايه الغلط اللي في الـ Procedure عشان اصلحه و الـError ده ميطلعش تاني