USP_DATAFORMTEMPLATE_EDIT_ANALYTICSPROJECT

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ANALYTICSPROJECT (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DATE date,
    @RECALIBRATION bit,
    @RECORDSSCORED integer,
    @SPECIFIEDRECORDCOUNT bit,
    @RECORDSBOUGHT integer,
    @DESCRIPTION nvarchar(max),
    @DISTRIBUTION varbinary(max),
    @DISTRIBUTIONFILENAME nvarchar(255),
    @DISTRIBUTIONFILECHANGED bit,
    @MODELSANDFREQUENCIES xml
)
as
begin
    set nocount on;

    declare @PRESENTATION1 varbinary(max) = null,
            @PRESENTATION2 varbinary(max) = null,
            @PRESENTATION3 varbinary(max) = null,
            @PRESENTATION4 varbinary(max) = null,
            @PRESENTATION5 varbinary(max) = null,
            @PRESENTATION1FILECHANGED bit = 0,
            @PRESENTATION2FILECHANGED bit = 0,
            @PRESENTATION3FILECHANGED bit = 0,
            @PRESENTATION4FILECHANGED bit = 0,
            @PRESENTATION5FILECHANGED bit = 0,
            @PRESENTATION1FILENAME nvarchar(255) = null,
            @PRESENTATION2FILENAME nvarchar(255) = null,
            @PRESENTATION3FILENAME nvarchar(255) = null,
            @PRESENTATION4FILENAME nvarchar(255) = null,
            @PRESENTATION5FILENAME nvarchar(255) = null,
            @PRESENTATION1INDEX tinyint = 0,
            @PRESENTATION2INDEX tinyint = 1,
            @PRESENTATION3INDEX tinyint = 2,
            @PRESENTATION4INDEX tinyint = 3,
            @PRESENTATION5INDEX tinyint = 4;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ANALYTICSPROJECT
        @ID=@ID,
        @PRESENTATION1=@PRESENTATION1 output,
        @PRESENTATION2=@PRESENTATION2 output,
        @PRESENTATION3=@PRESENTATION3 output,
        @PRESENTATION4=@PRESENTATION4 output,
        @PRESENTATION5=@PRESENTATION5 output,
        @PRESENTATION1FILECHANGED=@PRESENTATION1FILECHANGED output,
        @PRESENTATION2FILECHANGED=@PRESENTATION2FILECHANGED output,
        @PRESENTATION3FILECHANGED=@PRESENTATION3FILECHANGED output,
        @PRESENTATION4FILECHANGED=@PRESENTATION4FILECHANGED output,
        @PRESENTATION5FILECHANGED=@PRESENTATION5FILECHANGED output,
        @PRESENTATION1FILENAME=@PRESENTATION1FILENAME output,
        @PRESENTATION2FILENAME=@PRESENTATION2FILENAME output,
        @PRESENTATION3FILENAME=@PRESENTATION3FILENAME output,
        @PRESENTATION4FILENAME=@PRESENTATION4FILENAME output,
        @PRESENTATION5FILENAME=@PRESENTATION5FILENAME output,
        @PRESENTATION1INDEX=@PRESENTATION1INDEX output,
        @PRESENTATION2INDEX=@PRESENTATION2INDEX output,
        @PRESENTATION3INDEX=@PRESENTATION3INDEX output,
        @PRESENTATION4INDEX=@PRESENTATION4INDEX output,
        @PRESENTATION5INDEX=@PRESENTATION5INDEX output;

    exec USP_DATAFORMTEMPLATE_EDIT_ANALYTICSPROJECT_2
        @ID,
        @CHANGEAGENTID,
        @DATE,
        @RECALIBRATION,
        @RECORDSSCORED,
        @SPECIFIEDRECORDCOUNT,
        @RECORDSBOUGHT,
        @DESCRIPTION,
        @DISTRIBUTION,
        @DISTRIBUTIONFILENAME,
        @DISTRIBUTIONFILECHANGED,
        @MODELSANDFREQUENCIES,
        @PRESENTATION1,
        @PRESENTATION2,
        @PRESENTATION3,
        @PRESENTATION4,
        @PRESENTATION5,
        @PRESENTATION1FILECHANGED,
        @PRESENTATION2FILECHANGED,
        @PRESENTATION3FILECHANGED,
        @PRESENTATION4FILECHANGED,
        @PRESENTATION5FILECHANGED,
        @PRESENTATION1FILENAME,
        @PRESENTATION2FILENAME,
        @PRESENTATION3FILENAME,
        @PRESENTATION4FILENAME,
        @PRESENTATION5FILENAME,
        @PRESENTATION1INDEX,
        @PRESENTATION2INDEX,
        @PRESENTATION3INDEX,
        @PRESENTATION4INDEX,
        @PRESENTATION5INDEX;

end