UFN_SUGGESTEDMEMBERSHIPLEVEL_GETVALUE

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

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

                return @SCORE;
            end