USP_ADDETLREFRESHPARAMETERS

CREATE procedure dbo.USP_ADDETLREFRESHPARAMETERS

    /* Used by the USP_UDM_OLAPDATASOURCE_CREATEORUPDATE routine that registers data marts */


    @ID uniqueidentifier, -- The ID from a row in dbo.OLAPDATASOURCE


    @CHANGEAGENTID uniqueidentifier = null

    as

        set nocount on;

        if @CHANGEAGENTID is null
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @SOURCENAME nvarchar(255);

    select @SOURCENAME = SOURCENAME from dbo.OLAPDATASOURCE WHERE ID=@ID;    

        if not exists(select 1 from dbo.[ETLREFRESHPROCESS] where [OLAPDATASOURCEID] = @ID)
            insert dbo.[ETLREFRESHPROCESS] 
                ([OLAPDATASOURCEID], [SOURCENAME], [ADDEDBYID], [CHANGEDBYID]) 
                values 
                (@ID, @SOURCENAME, @CHANGEAGENTID, @CHANGEAGENTID)
    else
        update dbo.[ETLREFRESHPROCESS] set [SOURCENAME]=@SOURCENAME, [CHANGEDBYID]=@CHANGEAGENTID where [SOURCENAME] <> @SOURCENAME and [ID] = @ID;