USE [Risikomodell]
GO
/****** Object:  StoredProcedure [dbo].[pRiskModell_99_Caller]    Script Date: 29.08.2025 15:18:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*********************************************************************************************************
-- Author:		Hans-Willi Jackmuth
-- Create date: 28.08.2025
-- Description:	Create and Calculate Riskmodels for Audit - Procedure after creating the tables
*********************************************************************************************************/

ALTER PROCEDURE [dbo].[pRiskModell_99_Caller]
AS
BEGIN
	SET NOCOUNT ON;
	
-- #############################################
-- Integrate normal results into the model table
-- #############################################
	EXEC [dbo].[pRiskModell_11_ResultsNormal]
	EXEC [dbo].[pRiskModell_12_ResultsNormalCalc]
-- #############################################
-- Integrate weighted results into the model table
-- #############################################
	EXEC [dbo].[pRiskModell_21_ResultsWeighted]
	EXEC [dbo].[pRiskModell_22_ResultsWeightedCalc]

END
