CREATE PROCEDURE [dbo].[up_get_other_character]
	@character_id [uniqueidentifier],
	@server		  smallint
as begin

set nocount on
 set transaction isolation level read uncommitted

	select 
       [Name]
      ,[Class]
      ,[Job]
      ,[Level]
    from CharacterTable where character_id = @character_id --and server = @server
end