USP_DATATUNEUP_CREATEORUPDATE

Creates or updates the data tune up settings row.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@ADDRESSFORMATTINGCODE	tinyint	IN
@DONOTABBREVIATE	bit	IN
@CAPITALIZE	bit	IN
@UPDATEADDRESSCODE	tinyint	IN
@SAVEFORMERADDRESS	bit	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            create procedure dbo.USP_DATATUNEUP_CREATEORUPDATE (
                @ID uniqueidentifier = null output,
                @ADDRESSFORMATTINGCODE tinyint = null,
                @DONOTABBREVIATE bit = null,
                @CAPITALIZE bit = null,
                @UPDATEADDRESSCODE tinyint = null,
                @SAVEFORMERADDRESS bit = null,
                @ADDRESSTYPECODEID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null
            ) as begin
                set nocount on;

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

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                if exists(select 1 from dbo.DATATUNEUP) begin
                    select @ID = ID from dbo.DATATUNEUP order by DATEADDED;

                    update dbo.DATATUNEUP set
                        ADDRESSFORMATTINGCODE = @ADDRESSFORMATTINGCODE,
                        DONOTABBREVIATE = @DONOTABBREVIATE,
                        CAPITALIZE = @CAPITALIZE,
                        UPDATEADDRESSCODE = @UPDATEADDRESSCODE,
                        SAVEFORMERADDRESS = @SAVEFORMERADDRESS,
                        ADDRESSTYPECODEID = @ADDRESSTYPECODEID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID;
                end
                else begin
                    if @ID is null
                        set @ID = newid();

                    insert into dbo.DATATUNEUP (
                        ID,
                        ADDRESSFORMATTINGCODE,
                        DONOTABBREVIATE,
                        CAPITALIZE,
                        UPDATEADDRESSCODE,
                        SAVEFORMERADDRESS,
                        ADDRESSTYPECODEID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    ) values (
                        @ID,
                        @ADDRESSFORMATTINGCODE,
                        @DONOTABBREVIATE,
                        @CAPITALIZE,
                        @UPDATEADDRESSCODE,
                        @SAVEFORMERADDRESS,
                        @ADDRESSTYPECODEID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    );
                end

                return 0;
            end