USP_BBATARGETGIFTRANGESFILEIMPORT_UPDATEANALYTICSMODELFROMRANGES

            create procedure dbo.USP_BBATARGETGIFTRANGESFILEIMPORT_UPDATEANALYTICSMODELFROMRANGES
            (
                @CHANGEAGENTID uniqueidentifier
            ) as
                set nocount on;

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

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

                begin try

                    declare @ANALYTICSMODELID uniqueidentifier = N'CA0A6B61-2201-482F-AE8D-C6AE6852C318'; --Target gift range score category


                    declare @MAXIMUMVALUE nvarchar(50);
                    select top 1 @MAXIMUMVALUE = TARGETGIFTRANGE.RANGE from dbo.TARGETGIFTRANGE order by TARGETGIFTRANGE.SCORE desc;
                    set @MAXIMUMVALUE = coalesce(@MAXIMUMVALUE, N'');

                    declare @MINIMUMVALUE nvarchar(50);
                    select top 1 @MINIMUMVALUE = TARGETGIFTRANGE.RANGE from dbo.TARGETGIFTRANGE order by TARGETGIFTRANGE.SCORE asc;
                    set @MINIMUMVALUE = coalesce(@MINIMUMVALUE, N'');

                    update dbo.ANALYTICSMODEL set
                        MAXIMUMVALUE = @MAXIMUMVALUE,
                        MINIMUMVALUE = @MINIMUMVALUE,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ANALYTICSMODEL.ID = @ANALYTICSMODELID
                        and
                        (
                            ANALYTICSMODEL.MAXIMUMVALUE <> @MAXIMUMVALUE
                            or ANALYTICSMODEL.MINIMUMVALUE <> @MINIMUMVALUE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;