[GM] Reflexs]]

استخدم الكويري ده

USE [SRO_VT_SHARD]  
 DECLARE @Char**** Varchar (MAX)  
 DECLARE @Graduates INT  
 DECLARE @HonorPoints INT  
 DECLARE @CharID INT  
 DECLARE @CampID INT  
 SET        @Char**** = '_2ReaiS_'  
 SET        @CharID = (Select CharID FROM _Char Where Char****16 = @Char****)  
 SET        @CampID    = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)  
 SET        @Graduates    =    '1234'  
 SET        @HonorPoints=    @Graduates * 39  
  
 --------------------  
  
 UPDATE [Dbo].[_TrainingCamp]  
 SET GraduateCount = @Graduates  
 WHERE [Dbo].[_TrainingCamp].[ID] = @CampID  
 UPDATE [dbo].[_TrainingCampMember]  
 SET HonorPoint = @HonorPoints  
 WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID