USP_DATALIST_SUGGESTEDMEMBERSHIPLEVELS

Returns a list of all suggested membership levels in the system.

Definition

Copy


                CREATE procedure dbo.USP_DATALIST_SUGGESTEDMEMBERSHIPLEVELS
                as
                    set nocount on;

                    select
                        SML.ID,
                        SML.SCORE,
                        SML.RANGE
                    from
                        dbo.SUGGESTEDMEMBERSHIPLEVEL SML
                    order by
                        SML.SCORE asc;