USP_SESSION_TERM_COMPARE

       CREATE PROC USP_SESSION_TERM_COMPARE
        (
            @FROM_SESSIONID uniqueidentifier,
            @TO_SESSIONID uniqueidentifier,
            @SESSION_TERM_MATCH bit = 0 output
        )
        as
        begin

            set @SESSION_TERM_MATCH = 0 ;

            if not exists(
                    select 1
                    from dbo.TERMNAMECODE
                          left join dbo.TERM FROM_TERM on
                                TERMNAMECODE.ID = FROM_TERM.TERMNAMECODEID and
                                FROM_TERM.SESSIONID = @FROM_SESSIONID
                          left join dbo.TERM TO_TERM on
                                TERMNAMECODE.ID = TO_TERM.TERMNAMECODEID and
                                TO_TERM.SESSIONID = @TO_SESSIONID
                    where (FROM_TERM.ID is null and TO_TERM.ID is not null) or
                          (FROM_TERM.ID is not null and TO_TERM.ID is null)
                    )
              set @SESSION_TERM_MATCH = 1
        end ;