UFN_RE7REVENUE_GETREVENUEDESCRIPTION

create function dbo.UFN_RE7REVENUE_GETREVENUEDESCRIPTION(@ID int)
returns  nvarchar(255)
as
begin
    return (
                select
            [C].[FULLNAME] + ' - ' + [TC].[DESCRIPTION] + ' - ' + [F].[DESCRIPTION] 
            from dbo.[RE7_REVENUESPLIT] [RS]
            left outer join dbo.[RE7_REVENUE] [R] on [RS].[REVENUE_LOCALID] = [R].[LOCALID]
            left outer join dbo.[RE7_CONSTITUENT] [C] on [R].[CONSTITUENT_LOCALID] = [C].[LOCALID]
            left outer join dbo.[RE7_REVENUETYPECODE] [TC] on [R].[TYPECODE_LOCALID] = [TC].[LOCALID]
            left outer join dbo.[RE7_FUND] [F] on [RS].[FUND_LOCALID] = [F].[LOCALID]
            where [RS].[LOCALID] = @ID
    )
end