UFN_BATCHCONSTITUENTUPDATE_GETINTERESTS

Returns all interests for a given batch constituentupdate record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHCONSTITUENTUPDATE_GETINTERESTS(
        @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
        select
                ID,
                CONSTITUENTINTERESTCODEID,
                NOTE,
                CONSTITUENTINTERESTID
        from
                dbo.BATCHCONSTITUENTUPDATEINTERESTS
        where
                BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);