UFN_PACKAGEDITEMSSOLDTOGETHER

Verifies that items packaged together are tied to the same revenue

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@AUCTIONPACKAGEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PACKAGEDITEMSSOLDTOGETHER
            (
                @AUCTIONPACKAGEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @PACKAGEREVENUEID uniqueidentifier;
                declare @WRONGREVENUECOUNT integer;

                select @PACKAGEREVENUEID = AUCTIONITEM.REVENUEPURCHASEID
                from dbo.AUCTIONITEM
                where AUCTIONITEM.ID = @AUCTIONPACKAGEID

                set @WRONGREVENUECOUNT = (
                    select count(*) from dbo.AUCTIONITEM
                    where AUCTIONITEM.PACKAGEID = @AUCTIONPACKAGEID
                    and not AUCTIONITEM.REVENUEPURCHASEID = @PACKAGEREVENUEID
                );

                if @WRONGREVENUECOUNT = 0
                    return 1;

                return 0;
            end