UFN_SALESORDER_ITINERARY

        create function dbo.UFN_SALESORDER_ITINERARY (@SALESORDERID uniqueidentifier)
        returns table
        as
        return (
            select
                ID,
                left(NAME,90) as ITINERARYNAME,
                dbo.UFN_CONSTITUENT_BUILDNAME(LEADERID) as LEADERNAME,
                coalesce(
                    (
                        select sum(QUANTITY) from dbo.ITINERARYATTENDEE 
                        where ITINERARYID = ITINERARY.ID
                    ), 0
                ) as NUMBEROFVISITORS,
                dbo.UFN_HOURMINUTE_GETFROMDATE(ITINERARY.STARTDATETIME) as STARTDATETIME,
                dbo.UFN_HOURMINUTE_GETFROMDATE(ITINERARY.ENDDATETIME) as ENDDATETIME,
                dbo.UFN_GROUPSALESGROUPTYPECODE_GETDESCRIPTION(ITINERARY.GROUPSALESGROUPTYPECODEID) as GROUPTYPE
            from dbo.ITINERARY
            where 
                RESERVATIONID = @SALESORDERID
            )