CREATE PROCEDURE [dbo].[up_insert_reward]
@type				tinyint,
@grade				int

as
set nocount on

insert into RewardTable( reward_type, character_id, character_name, reward_grade )
select rank_type, character_id, char_name, grade
	from BattleRank
	with (READUNCOMMITTED)
	where [rank_type] = @type and [grade] <= @grade