UFN_CONSTITUENTBATCH_GETGROUPMEMBERS

Returns all members of a constituent group.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@BATCHCONSTITUENTID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_CONSTITUENTBATCH_GETGROUPMEMBERS
            (
                @BATCHCONSTITUENTID uniqueidentifier
            ) returns table
            as
              return
              (
                  select
                      ID,
                      CONSTITUENTID,
                      ISPRIMARY
                  from
                      dbo.BATCHCONSTITUENTGROUPMEMBER
                  where
                      BATCHCONSTITUENTID = @BATCHCONSTITUENTID
              );