USP_DATALIST_SPONSORSHIPTERMINATEPROCESS

      create procedure dbo.USP_DATALIST_SPONSORSHIPTERMINATEPROCESS
      as
          set nocount on;

        select
          SPONSORSHIPTERMINATEPROCESS.ID,
              SPONSORSHIPTERMINATEPROCESS.NAME,
              SPONSORSHIPTERMINATEPROCESS.DESCRIPTION,
              IDSET.NAME as SELECTION,
          SPR.REASON
        from 
      dbo.SPONSORSHIPTERMINATEPROCESS
              inner join dbo.IDSETREGISTER as IDSET on SPONSORSHIPTERMINATEPROCESS.IDSETREGISTERID = IDSET.ID              
          inner join dbo.SPONSORSHIPREASON as SPR on SPONSORSHIPTERMINATEPROCESS.SPONSORSHIPREASONID = SPR.ID