UFN_ITINERARYSTAFFRESOURCE_ITINERARYHASITEMS

            create function dbo.UFN_ITINERARYSTAFFRESOURCE_ITINERARYHASITEMS
            (
                @ITINERARYSTAFFRESOURCEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @RETVAL bit = 0;

                if (exists (select ITINERARYITEM.ID
                            from dbo.ITINERARYITEM
                                inner join dbo.ITINERARYSTAFFRESOURCE
                                    on ITINERARYITEM.ITINERARYID = ITINERARYSTAFFRESOURCE.ITINERARYID
                            where (ITINERARYSTAFFRESOURCE.ID = @ITINERARYSTAFFRESOURCEID)))
                    set @RETVAL = 1;

                return @RETVAL;
            end