UFN_CONSTITUENT_GETINTERESTS_FORUPDATEBATCH

This function returns a constituent's phones for the update batch given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_GETINTERESTS_FORUPDATEBATCH(@CONSTITUENTID uniqueidentifier)
            returns table
            as return
                select
                    CI.[CONSTITUENTINTERESTCODEID],
                    coalesce(CI.[NOTE], '') as NOTE,
                    CI.[ID] as CONSTITUENTINTERESTID
                from
                    dbo.[CONSTITUENTINTEREST] CI
                where
                    CI.[CONSTITUENTID] = @CONSTITUENTID;