
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_claim_variables_add]
	@claim_id int,
	@variables type_table_id2 READONLY
AS

	/*
	DGE
	Ajouter les variables contenues dans la table @variables.

	*/

	insert	into claim_variables(clv_claim_id, clv_variable_id, clv_company_id)
	select	@claim_id, id1, id2
	from	@variables

GO
