USP_SIMPLEDATALIST_ITINERARY

            CREATE procedure dbo.USP_SIMPLEDATALIST_ITINERARY
            (
                @RESERVATIONID uniqueidentifier,
                @ITINERARYID uniqueidentifier = null
            )
            as


                select 
                    ID as VALUE, 
                    case
                        when LEADERID is null then
                            NAME
                        else NAME + ' - ' + dbo.UFN_CONSTITUENT_BUILDNAME(LEADERID) 
                    end as LABEL
                from dbo.ITINERARY
                where 
                    RESERVATIONID = @RESERVATIONID and
                    (ID <> @ITINERARYID or @ITINERARYID is null)
                order by ID