UFN_REGISTRANT_GETDESIGNATIONS

CREATE function dbo.UFN_REGISTRANT_GETDESIGNATIONS
(
    @REGISTRANTID uniqueidentifier
)
returns table
as
return
(
    select 
        REGISTRANTDESIGNATION.ID, 
        REGISTRANTDESIGNATION.DESIGNATIONID, 
        REGISTRANTDESIGNATION.AMOUNT,
        EVENT.BASECURRENCYID
    from 
        dbo.REGISTRANTDESIGNATION
        join dbo.REGISTRANT on REGISTRANT.ID = REGISTRANTDESIGNATION.REGISTRANTID
        join dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
    where 
        REGISTRANTID = @REGISTRANTID
)