SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =========================================================================================
-- Author:		Laba Catalin
-- Create date: 14/01/2011
-- Description:	Returns the risk detail, complement and variables
-- =========================================================================================
CREATE procedure [dbo].[p_risk_situations_list]
	@risk_id int
as 
	set nocount on;
	
	select r.*, s.*
	from ris_risks r
		inner join ris_risks_situations s on	ris_risk_id = riss_risk_id 
	where r.ris_risk_id = @risk_id
GO
