USP_BBASUGGESTEDMEMBERSHIPLEVELSFILEIMPORT_UPDATEANALYTICSMODELFROMRANGES

            create procedure dbo.USP_BBASUGGESTEDMEMBERSHIPLEVELSFILEIMPORT_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'A4BACAA3-8EE4-4476-B359-428E582C42AE'; --Suggested membership level score category


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

                    declare @MINIMUMVALUE nvarchar(50);
                    select top 1 @MINIMUMVALUE = SUGGESTEDMEMBERSHIPLEVEL.RANGE from dbo.SUGGESTEDMEMBERSHIPLEVEL order by SUGGESTEDMEMBERSHIPLEVEL.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;