USP_DATALIST_RATESCALE

            CREATE procedure dbo.USP_DATALIST_RATESCALE
            as
                set nocount on;

                select 
                    RATESCALE.ID,
                    RATESCALE.NAME,
                    RATESCALE.DESCRIPTION,
                    RATESCALE.ISDEFAULT,
                    GROUPSALESGROUPTYPECODE.DESCRIPTION as GROUPSALESGROUPTYPECODE,
                    RATESCALE.ISACTIVE
                from dbo.RATESCALE
                    left outer join dbo.GROUPSALESGROUPTYPECODE
                        on RATESCALE.GROUPSALESGROUPTYPECODEID = GROUPSALESGROUPTYPECODE.ID