SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[p_doc_collections_get_collections_by_table_id]
	@table_id type_table_id READONLY
AS

	/*
	DGE 29/02/2016

	Cette procédure renvoie les collections contenue dans @table_id

	*/

	select	c.*
	from	doc_collections c
			inner join @table_id t on t.id = c.dc_collection_id
	order by c.dc_operation_utc_date desc
GO
