UFN_BBNC_GETDESIGNATIONIDFROMDONATIONDESIGNATIONSID

create function dbo.UFN_BBNC_GETDESIGNATIONIDFROMDONATIONDESIGNATIONSID (
    @DONATIONDESIGNATIONSID int,
    @PARTID int
)
returns uniqueidentifier
as
begin
    return
    (
        select top 1
            MAP.DESIGNATIONID
        from
            dbo.DONATIONDESIGNATIONS DD
        left join
            dbo.BBNCDESIGNATIONIDMAP MAP on MAP.ID = DD.BackOfficeID
        inner join
            dbo.ClientDonations CD on CD.ID = DD.ClientDonationsID
        where
            DD.ID = @DONATIONDESIGNATIONSID and
            CD.ContentID = @PARTID
    );
end