USP_MERGETASKCATALOG_CREATEORUPDATE

Adds a merge task spec to the database or updates an existing merge task spec.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(255)	IN
@DESCRIPTION	nvarchar(1000)	IN
@SPNAME	nvarchar(100)	IN
@UIFOLDER	nvarchar(255)	IN
@RECORDTYPE	nvarchar(50)	IN
@SPECXML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            create procedure dbo.USP_MERGETASKCATALOG_CREATEORUPDATE(@ID uniqueidentifier,
                @NAME nvarchar(255),
                @DESCRIPTION nvarchar(1000),
                @SPNAME nvarchar(100),
                @UIFOLDER nvarchar(255),
                @RECORDTYPE nvarchar(50),
                @SPECXML xml,
                @CHANGEAGENTID uniqueidentifier)
            as
                set nocount on;

                declare @RecTypeID uniqueidentifier;

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

                --Add record type if it does not exist.        

                exec dbo.USP_RECORDTYPE_GETID_OR_CREATE_FROMNAME @NAME=@RECORDTYPE,@CHANGEAGENTID=@CHANGEAGENTID,@RECORDTYPEID=@RecTypeID output;

                if exists(select ID from dbo.MERGETASKCATALOG where ID = @ID)
                begin
                    update dbo.MERGETASKCATALOG set NAME = @NAME,
                        DESCRIPTION = @DESCRIPTION,
                        SPNAME = @SPNAME,
                        UIFOLDER = @UIFOLDER,
                        RECORDTYPEID = @RecTypeID,
                        SPECXML = @SPECXML,
                        DATECHANGED = getdate(),
                        CHANGEDBYID = @CHANGEAGENTID
                    where ID = @ID;
                end
                else
                begin
                    insert into dbo.MERGETASKCATALOG (ID,
                        NAME,
                        DESCRIPTION,
                        SPNAME,
                        UIFOLDER,
                        RECORDTYPEID,
                        SPECXML,
                        DATEADDED,
                        DATECHANGED,
                        ADDEDBYID,
                        CHANGEDBYID)
                    values (@ID,
                        @NAME,
                        @DESCRIPTION,
                        @SPNAME,
                        @UIFOLDER,
                        @RecTypeID,
                        @SPECXML,
                        getdate(),
                        getdate(),
                        @CHANGEAGENTID,
                        @CHANGEAGENTID);
                end;