UFN_ITINERARY_TOTALVISITORCOUNT

Returns the number of visitors for an itinerary.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_ITINERARY_TOTALVISITORCOUNT(@ITINERARYID uniqueidentifier)
            returns int
            with execute as caller
            as begin
                return isnull((select sum(ITINERARYATTENDEE.QUANTITY)
                                from dbo.ITINERARYATTENDEE
                                where ITINERARYID = @ITINERARYID
                            ), 0);
            end