USP_TRIBUTE_GETTRANSACTIONDATA

CREATE procedure dbo.USP_TRIBUTE_GETTRANSACTIONDATA
(
@ID uniqueidentifier
)
as
begin
select 
    t.TRIBUTETEXT as Description,
    c.FIRSTNAME as First,
    c.KEYNAME as Last,
    ttc.DESCRIPTION as Type
from 
    dbo.TRIBUTE t 
    inner join TRIBUTETYPECODE ttc
        on t.TRIBUTETYPECODEID = ttc.ID
  left join CONSTITUENT c 
        on t.TRIBUTEEID = c.ID
where t.ID=@ID;

end