USP_DATAFORMTEMPLATE_VIEW_ANALYTICSPROJECT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@DATE	date	INOUT
@RECALIBRATION	bit	INOUT
@RECORDSSCORED	int	INOUT
@RECORDSBOUGHT	int	INOUT
@DESCRIPTION	nvarchar(max)	INOUT
@USEDBEFORE	bit	INOUT
@PRESENTATION1	varbinary	INOUT
@PRESENTATION2	varbinary	INOUT
@PRESENTATION3	varbinary	INOUT
@PRESENTATION4	varbinary	INOUT
@PRESENTATION5	varbinary	INOUT
@PRESENTATION1FILENAME	nvarchar(255)	INOUT
@PRESENTATION2FILENAME	nvarchar(255)	INOUT
@PRESENTATION3FILENAME	nvarchar(255)	INOUT
@PRESENTATION4FILENAME	nvarchar(255)	INOUT
@PRESENTATION5FILENAME	nvarchar(255)	INOUT
@PRESENTATION1INDEX	tinyint	INOUT
@PRESENTATION2INDEX	tinyint	INOUT
@PRESENTATION3INDEX	tinyint	INOUT
@PRESENTATION4INDEX	tinyint	INOUT
@PRESENTATION5INDEX	tinyint	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ANALYTICSPROJECT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @DATE date = null output,
    @RECALIBRATION bit = null output,
    @RECORDSSCORED int = null output,
    @RECORDSBOUGHT int = null output,
    @DESCRIPTION nvarchar(max) = null output,
    @USEDBEFORE bit = null output,
    @PRESENTATION1 varbinary(max) = null output,
    @PRESENTATION2 varbinary(max) = null output,
    @PRESENTATION3 varbinary(max) = null output,
    @PRESENTATION4 varbinary(max) = null output,
    @PRESENTATION5 varbinary(max) = null output,
    @PRESENTATION1FILENAME nvarchar(255) = null output,
    @PRESENTATION2FILENAME nvarchar(255) = null output,
    @PRESENTATION3FILENAME nvarchar(255) = null output,
    @PRESENTATION4FILENAME nvarchar(255) = null output,
    @PRESENTATION5FILENAME nvarchar(255) = null output,
    @PRESENTATION1INDEX tinyint = null output,
    @PRESENTATION2INDEX tinyint = null output,
    @PRESENTATION3INDEX tinyint = null output,
    @PRESENTATION4INDEX tinyint = null output,
    @PRESENTATION5INDEX tinyint = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @DATE = ANALYTICSPROJECT.DATE,
        @RECALIBRATION = ANALYTICSPROJECT.RECALIBRATION,
        @RECORDSSCORED = ANALYTICSPROJECT.RECORDSSCORED,
        @RECORDSBOUGHT = ANALYTICSPROJECT.RECORDSBOUGHT,
        @DESCRIPTION = ANALYTICSPROJECT.DESCRIPTION,
        @USEDBEFORE = case when exists (select 1 from dbo.MODELINGANDPROPENSITYDELIVERY where ANALYTICSPROJECTID = @ID) then 1 else 0 end,
        @PRESENTATION1 = null, /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
        @PRESENTATION2 = null, /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
        @PRESENTATION3 = null, /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
        @PRESENTATION4 = null, /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
        @PRESENTATION5 = null, /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
        @PRESENTATION1FILENAME = ANALYTICSPROJECT.PRESENTATION1FILENAME,
        @PRESENTATION2FILENAME = ANALYTICSPROJECT.PRESENTATION2FILENAME,
        @PRESENTATION3FILENAME = ANALYTICSPROJECT.PRESENTATION3FILENAME,
        @PRESENTATION4FILENAME = ANALYTICSPROJECT.PRESENTATION4FILENAME,
        @PRESENTATION5FILENAME = ANALYTICSPROJECT.PRESENTATION5FILENAME,
        @PRESENTATION1INDEX = ANALYTICSPROJECT.PRESENTATION1INDEX,
        @PRESENTATION2INDEX = ANALYTICSPROJECT.PRESENTATION2INDEX,
        @PRESENTATION3INDEX = ANALYTICSPROJECT.PRESENTATION3INDEX,
        @PRESENTATION4INDEX = ANALYTICSPROJECT.PRESENTATION4INDEX,
        @PRESENTATION5INDEX = ANALYTICSPROJECT.PRESENTATION5INDEX
    from
        dbo.ANALYTICSPROJECT
    where
        ANALYTICSPROJECT.ID = @ID;

    return 0;