USP_DATALIST_EVENTSPONSOR

      CREATE procedure dbo.USP_DATALIST_EVENTSPONSOR
      (
        @EVENTID uniqueidentifier,
        @SORTORDER Tinyint = 0 -- 0:Desc, 1:ASC

      )
      as
          set nocount on;


        IF @SORTORDER = 0
          SELECT ISNULL(OC.NAME, C.NAME) AS NAME, 
          C.ID as CONSTITUENTID,
          ES.ID as EVENTSPONSORRECORDID, 
          ST.NAME as SPONSORSHIPLEVEL, 
          ES.EVENTSPONSORSHIPLOGOID, 
          ES.EVENTSPONSORSHIPURL, 
          ES.FEESAMOUNT,
          ES.SPONSORSHIPMESSAGE,
          ES.ALLOWADMINACCESSHQ          
        FROM dbo.EVENTSPONSOR ES (NOLOCK)
        INNER JOIN dbo.EVENTSPONSORSHIPTYPE ST (NOLOCK)
        ON ES.EVENTSPONSORSHIPTYPEID = ST.ID
        INNER JOIN dbo.CONSTITUENT C (NOLOCK)
        ON C.ID = ES.CONSTITUENTID
          LEFT OUTER JOIN dbo.CONSTITUENT OC(NOLOCK)
            ON OC.ID = ES.ORGANIZATIONCONSTITUENTID
        WHERE ES.EVENTID = @EVENTID
        AND ES.ISCANCELLED = 0
        ORDER BY ES.FEESAMOUNT DESC, ISNULL(OC.KEYNAME, C.KEYNAME) DESC, NAME DESC

        IF @SORTORDER = 1
          SELECT ISNULL(OC.NAME, C.NAME) AS NAME, 
          C.ID as CONSTITUENTID,
          ES.ID as EVENTSPONSORRECORDID,  
          ST.NAME as SPONSORSHIPLEVEL, 
          ES.EVENTSPONSORSHIPLOGOID, 
          ES.EVENTSPONSORSHIPURL, 
          ES.FEESAMOUNT,
          ES.SPONSORSHIPMESSAGE,
          ES.ALLOWADMINACCESSHQ
        FROM dbo.EVENTSPONSOR ES (NOLOCK)
        INNER JOIN dbo.EVENTSPONSORSHIPTYPE ST (NOLOCK)
        ON ES.EVENTSPONSORSHIPTYPEID = ST.ID
        INNER JOIN dbo.CONSTITUENT C (NOLOCK)
        ON C.ID = ES.CONSTITUENTID
          LEFT OUTER JOIN dbo.CONSTITUENT OC(NOLOCK)
            ON OC.ID = ES.ORGANIZATIONCONSTITUENTID
        WHERE ES.EVENTID = @EVENTID
        AND ES.ISCANCELLED = 0
        ORDER BY ES.FEESAMOUNT ASC, ISNULL(OC.KEYNAME, C.KEYNAME) ASC, NAME ASC