USP_DATALIST_FAFEVENTEMAILREADY

CREATE procedure dbo.USP_DATALIST_FAFEVENTEMAILREADY
as
    set nocount on;

    select top 100 ID,
           EVENTID,
           CONSTITUENTIDS,
           CONFIRMATIONTYPE,
       REVENUEID,
       GROUPID,
       REGISTRANTIDS,
       DONORID,
       CHILDGROUPIDS,
       COMMENTID,
       case when TRANSACTIONTYPECODE = 255 then null else TRANSACTIONTYPECODE end as TRANSACTIONTYPECODE,
       ORGANIZATIONCONSTITUENTID
    from dbo.FAFEVENTEMAILREADY
  order by DATEADDED ASC