UFN_TARGETGIFTRANGE_GETVALUE

create function dbo.UFN_TARGETGIFTRANGE_GETVALUE(@ID uniqueidentifier)
            returns smallint
            with execute as caller
            as begin
                declare @SCORE smallint;

                select 
                    @SCORE = SCORE 
                from 
                    dbo.TARGETGIFTRANGE
                where 
                    ID = @ID;

                return @SCORE;
            end