UFN_SEGMENT_ISVALIDFORSOLICITATION

            create function dbo.UFN_SEGMENT_ISVALIDFORSOLICITATION
            (
                @SEGMENTID uniqueidentifier,    
                @SOLICITATIONID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @COUNT int;

                if @SEGMENTID is null and @SOLICITATIONID is null
                    return 1;

                select @COUNT = count(SOLICITATIONSEGMENT.ID) 
                from SOLICITATIONSEGMENT
                where SEGMENTID = @SEGMENTID and SOLICITATIONID = @SOLICITATIONID;

                if @COUNT >= 1
                    return 1;

                return 0;
            end