ALTER PROCEDURE [dbo].[sp_calculate_main]
	@stype	VARCHAR( 20 )
	, @require	VARCHAR( 20 )
	, @params XML 
	, @id_out	VARCHAR( 20 ) OUTPUT 
	, @result VARCHAR( 10 ) OUTPUT
	, @out_text	VARCHAR( 200 ) OUTPUT
AS
BEGIN
	BEGIN TRY

	DECLARE @id BIGINT
	DECLARE @sp_result VARCHAR( 10 )
	DECLARE @sp_result_text VARCHAR( 200 )

	INSERT INTO CurrentCalc (Stype, Require,[Date], UserId, Percent_unit, Percent_total)
	VALUES (@stype, @require, GetDate(), dbo.ufnGetUserId(), - 1 , - 1 )
	
	SET @id = @@identity
	SET @id_out = CONVERT(VARCHAR( 20 ), @id)

	IF @stype =  1  and @require =  1 
	BEGIN 
			EXEC sp_calculate_S1R1 @id
				 , @sp_result OUTPUT
				, @sp_result_text OUTPUT
	END

	SELECT * 
		FROM CurrentCalc
		WHERE id = @id
	
	END TRY
	BEGIN CATCH
		SELECT * 
			FROM CurrentCalc
			WHERE id = @id
	END CATCH

END

SET NOCOUNT ON;