USP_SIMPLEDATALIST_REVENUETRIBUTE

                create procedure dbo.USP_SIMPLEDATALIST_REVENUETRIBUTE
                (
                    @REVENUEID uniqueidentifier = null
                )
                as
                    select 
                        RT.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;