USP_ADDOLAPDATASOURCEVALIDATIONPARAMETERS

CREATE procedure dbo.USP_ADDOLAPDATASOURCEVALIDATIONPARAMETERS(@ID uniqueidentifier,     @CHANGEAGENTID uniqueidentifier = null)

as
begin

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

    --Add default values for OLAP validation

        if not exists(select 1 from dbo.[OLAPDATASOURCEVALIDATIONPARAMETERS] where [OLAPDATASOURCEID] = @ID)
      insert dbo.[OLAPDATASOURCEVALIDATIONPARAMETERS] 
                ([OLAPDATASOURCEID], [INCLUDEEXTENSIONS], [RUNAFTERETL], [ADDEDBYID], [CHANGEDBYID]) 
                values 
                (@ID, 0, 0, @CHANGEAGENTID, @CHANGEAGENTID);

end