USP_DATALIST_ARCHIVEDAPPEALMAILINGCONTENT

create procedure dbo.USP_DATALIST_ARCHIVEDAPPEALMAILINGCONTENT
as
    set nocount on;

    select 
        ARCHIVEDAPPEALMAILINGCONTENT.ID,
        MKTSEGMENTATION.NAME,
        replace(ARCHIVEDAPPEALMAILINGCONTENT.DOCUMENTFILENAME, ' ', '_') as FILENAME,
        '798c7633-6fcb-47fa-b40f-37375749eb28' as VIEWFORMID,
        'DOCUMENTFILE' as FILEFIELDID
    from dbo.ARCHIVEDAPPEALMAILINGCONTENT
    inner join dbo.MKTSEGMENTATION
        on ARCHIVEDAPPEALMAILINGCONTENT.ID = MKTSEGMENTATION.ID;