UFN_CONSTITUENT_HASPREREGISTEREDTICKETSTOEVENT

Returns a bit determining if a constituent has any sales order item tickets to a given event.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_HASPREREGISTEREDTICKETSTOEVENT
            (
                @CONSTITUENTID uniqueidentifier,
                @EVENTID uniqueidentifier
            )
            returns bit
            as begin
                if exists (
                    select top 1 1 from dbo.SALESORDERITEMTICKETREGISTRANT
                    inner join dbo.REGISTRANT on REGISTRANT.ID = SALESORDERITEMTICKETREGISTRANT.REGISTRANTID
                    where REGISTRANT.EVENTID = @EVENTID and REGISTRANT.CONSTITUENTID = @CONSTITUENTID
                )
                    return 1;

                return 0;
            end