USP_DATAFORMTEMPLATE_VIEW_ANALYTICSMODELDETAIL

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@MODELNAME	nvarchar(100)	INOUT
@MODELMINIMUMVALUE	nvarchar(50)	INOUT
@MODELMAXIMUMVALUE	nvarchar(50)	INOUT
@MODELDESCRIPTION	nvarchar(500)	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ANALYTICSMODELDETAIL
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @MODELNAME nvarchar(100) = null output,
    @MODELMINIMUMVALUE nvarchar(50) = null output,
    @MODELMAXIMUMVALUE nvarchar(50) = null output,
    @MODELDESCRIPTION nvarchar(500) = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @MODELNAME = ANALYTICSMODEL.NAME,
        @MODELMINIMUMVALUE = ANALYTICSMODEL.MINIMUMVALUE,
        @MODELMAXIMUMVALUE = ANALYTICSMODEL.MAXIMUMVALUE,
        @MODELDESCRIPTION = ANALYTICSMODEL.DESCRIPTION
    from
        dbo.ANALYTICSMODEL
    where
        ANALYTICSMODEL.ID = @ID;

    return 0;