CREATE PROCEDURE [dbo].[up_read_dungeon_rank]
	@character_id     [uniqueidentifier]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 set transaction isolation level read uncommitted

    -- Insert statements for procedure here
	SELECT [world_id], [difficulty], [rank_normal], [rank_hard], [rank_veryhard] from DungeonRank where [character_id] = @character_id

return @@error
END