UFN_BATCHAUCTIONITEMGROUPMEMBER_PRIMARYCOUNT

This function retrieves the count of primary contacts for an auction item group

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCHAUCTIONITEMGROUPMEMBER_PRIMARYCOUNT(@GROUPID uniqueidentifier)
            returns int
            as
            begin
                return (select count(*) from dbo.BATCHAUCTIONITEMCONSTITUENTGROUPMEMBER where (GROUPID = @GROUPID) and (ISPRIMARY = 1))
            end