[TheBold]

المشاركة الأصلية كتبت بواسطة hodamoseba عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 408
Incorrect syntax near 'end'.

ممكن حل

دة البروسيد

  if(@Operation = 41 and @ItemRefID= '42279') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '5' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42280') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '6' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '422811') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '7' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42282') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '8' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42283') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '9' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42284') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '10' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42285') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '11' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42286') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '12' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42287') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '13' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42288') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '14' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42289') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '15' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42290') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '16' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42291') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '17' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42292') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '18' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42293') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '19' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42294') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '20' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42295') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '21' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42296') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '22' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42297') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '23' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42298') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '24' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42299') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '25' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42300') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '26' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42301') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '27' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42302') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '28' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42303') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '29' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42304') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '30' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42305') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '31' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42306') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '32' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42307') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '33' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42308') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '34' Where CharID = @CharID 

اسم الداتا عندك اية و اخر الـ HwanLevel عندكم كام ؟!