UFN_BATCHAUCTIONITEMCONSTITUENT_ISHOUSEHOLD

This function determines whether an auction item batch group is a household.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHAUCTIONITEMCONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BATCHAUCTIONITEMCONSTITUENT_ISHOUSEHOLD(@BATCHAUCTIONITEMCONSTITUENTID uniqueidentifier)
            returns bit
            begin
                return (select case when (select GROUPTYPECODE from dbo.BATCHAUCTIONITEMCONSTITUENT where ID=@BATCHAUCTIONITEMCONSTITUENTID) = 0 then 1 else 0 end);
            end