USP_SIMPLEDATALIST_TRIBUTE

CREATE procedure dbo.USP_SIMPLEDATALIST_TRIBUTE
                (
                    @REVENUEID uniqueidentifier = null
                )
                as
                    select 
                        TRIBUTE.ID as VALUE, 
                        TRIBUTE.TRIBUTETEXT as LABEL
                    from 
                        dbo.REVENUETRIBUTE RT
                    inner join
                        dbo.TRIBUTE on RT.TRIBUTEID = TRIBUTE.ID
                    where 
                        RT.REVENUEID = @REVENUEID or @REVENUEID is null
                    order by 
                        TRIBUTE.TRIBUTETEXT;