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

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

	*/

	delete	cv
	from	claim_variables cv
			inner join @variables v on v.id = cv.clv_variable_id
	where	cv.clv_claim_id = @claim_id
GO
