UFN_TRIBUTE_GETACKNOWLEDGEES

This SQL function returns all acknowledgees for a given tribute.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRIBUTEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_TRIBUTE_GETACKNOWLEDGEES
            (
                @TRIBUTEID uniqueidentifier
            )
            returns table
            as return
            (
                select
                    ID,
                    CONSTITUENTID,
                    TRIBUTELETTERCODEID,
                    SEQUENCE
                from
                    dbo.TRIBUTEACKNOWLEDGEE
                where
                    TRIBUTEID = @TRIBUTEID
            )