USP_DATALIST_SPONSORSHIPTRANSFERPROCESS

                 CREATE procedure dbo.USP_DATALIST_SPONSORSHIPTRANSFERPROCESS
      as
          set nocount on;

        select
          SPONSORSHIPTRANSFERPROCESS.ID,
              SPONSORSHIPTRANSFERPROCESS.NAME,
              SPONSORSHIPTRANSFERPROCESS.DESCRIPTION,
              IDSET.NAME as SELECTION,
          SPONSORSHIPTRANSFERPROCESS.SPONSORPREFERENCE,
          SPR.REASON,
          (select top 1 dbo.UFN_CHANGEAGENT_GETUSERNAME(SPTS.ADDEDBYID) from dbo.SPONSORSHIPTRANSFERPROCESSSTATUS SPTS where SPONSORSHIPTRANSFERPROCESS.ID = SPTS.PARAMETERSETID order by DATEADDED desc) PROCESSEDBY,
          (select top 1 SPTS.DATEADDED from dbo.SPONSORSHIPTRANSFERPROCESSSTATUS SPTS where SPONSORSHIPTRANSFERPROCESS.ID = SPTS.PARAMETERSETID order by DATEADDED desc) DATEPROCESSED
        from 
      dbo.SPONSORSHIPTRANSFERPROCESS
              inner join dbo.IDSETREGISTER as IDSET on SPONSORSHIPTRANSFERPROCESS.IDSETREGISTERID = IDSET.ID              
          inner join dbo.SPONSORSHIPREASON as SPR on SPONSORSHIPTRANSFERPROCESS.SPONSORSHIPREASONID = SPR.ID