UFN_MATCHINGGIFTCONDITION_GETSEQUENCES

This SQL function returns matching gift condition sequences for an organization.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ORGANIZATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_MATCHINGGIFTCONDITION_GETSEQUENCES
            (
                @ORGANIZATIONID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    MATCHINGGIFTCONDITION.ID,
                    MATCHINGGIFTCONDITIONTYPECODE.DESCRIPTION as TYPE,
                    MATCHINGGIFTCONDITION.SEQUENCE
                from
                    dbo.MATCHINGGIFTCONDITION
                left join
                    dbo.MATCHINGGIFTCONDITIONTYPECODE on MATCHINGGIFTCONDITIONTYPECODE.ID = MATCHINGGIFTCONDITIONTYPECODEID
                where
                    ORGANIZATIONID = @ORGANIZATIONID
            )