UFN_AUCTIONITEM_PACKAGEDITEMSSOLDTOGETHER

            CREATE function dbo.UFN_AUCTIONITEM_PACKAGEDITEMSSOLDTOGETHER
            (
                @AUCTIONPACKAGEID uniqueidentifier,
                @TYPECODE integer
            )
            returns bit
            with execute as caller
            as begin
                if @TYPECODE = 0
                    return 1;

                declare @PACKAGEREVENUEID uniqueidentifier;
                declare @WRONGREVENUECOUNT integer;

                select @PACKAGEREVENUEID = AUCTIONITEMREVENUEPURCHASE.REVENUEPURCHASEID
                from dbo.AUCTIONITEM
                left join AUCTIONITEMREVENUEPURCHASE on AUCTIONITEM.ID = AUCTIONITEMREVENUEPURCHASE.AUCTIONITEMID
                where AUCTIONITEM.ID = @AUCTIONPACKAGEID

                set @WRONGREVENUECOUNT = (
                    select count(*) from dbo.AUCTIONITEM left join dbo.AUCTIONITEMREVENUEPURCHASE on AUCTIONITEM.ID = AUCTIONITEMREVENUEPURCHASE.AUCTIONITEMID
                    where AUCTIONITEM.PACKAGEID = @AUCTIONPACKAGEID
                    and not AUCTIONITEMREVENUEPURCHASE.REVENUEPURCHASEID = @PACKAGEREVENUEID
                );

                if @WRONGREVENUECOUNT = 0
                    return 1;

                return 0;
            end