[che_9299]

USE [SRO_VT_SHARD]  
 DECLARE @CharName16 Varchar (64)  
 DECLARE @Graduates INT  
 DECLARE @HonorPoints INT  
 DECLARE @CharID INT  
 DECLARE @CampID INT  
 SET        @CharName16 = 'che_s4a'  
 SET        @CharID = (Select CharID FROM _Char Where CharName16 = @CharName16)  
 SET        @CampID    = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)  
 SET        @Graduates    =    '1'  
 SET        @HonorPoints=    @Graduates * 39

1.2.3.4