CREATE PROCEDURE [dbo].[up_update_quest]
@quest_uid	[uniqueidentifier],
@character_id	[uniqueidentifier],
@quest_state	tinyint,
@quest_status1  smallint,
@quest_status2  smallint,
@quest_status3  smallint,
@quest_status4  smallint,
@quest_status5  smallint,
@finsh_date		NVARCHAR(20)

as 
set nocount on

	update dbo.QuestTable set 
	quest_state   =	@quest_state,
	quest_status1 = @quest_status1,
	quest_status2 = @quest_status2,
	quest_status3 = @quest_status3,
	quest_status4 = @quest_status4,
	quest_status5 = @quest_status5,
	finish_time	  = convert( datetime, @finsh_date )

	where quest_uid = @quest_uid;

return @@error