spAddUploadedListToMasterList

            CREATE PROCEDURE [dbo].[spAddUploadedListToMasterList]
      (
      @ListID  int
      )
            AS
      BEGIN
        set nocount on

        declare @TABLENAME nvarchar(128);
        declare @EMAILADDRESSFIELD nvarchar(128)
        declare @EMAILADDRESSDISPLAYNAMEFIELD nvarchar(128)

        set @TABLENAME = dbo.fnUloadedListBuildTableName(@LISTID);

        SELECT @EMAILADDRESSFIELD =[EmailAddressFieldName], @EMAILADDRESSDISPLAYNAMEFIELD = EmailDisplayNameFieldName 
        FROM EmailList 
        WHERE [ID] = @ListID

        delete from dbo.EmailListUploadMasterList 
              where [emaillistID] = @listID

        declare @SQL nvarchar(4000);

        --- Add to EmailListUploadMasterList
        set @SQL = 'insert into dbo.EmailListUploadMasterList (guid, emaillistid, EmailAddress, EmailDisplayName) ' + char(13) + 
                 'select BB_XListRecordGuid, ' + cast(@LISTID as nvarchar(10)) + ', replace(replace([' + @EMAILADDRESSFIELD + '],CHAR(13),''''),CHAR(10),''''), [' + @EMAILADDRESSDISPLAYNAMEFIELD +
                 '] from ' + @TABLENAME 
        exec(@SQL)

        --- Add to BackOfficeSystemPeople
        merge dbo.BACKOFFICESYSTEMPEOPLE as T
        using (select BB_XListRecordID from EmailListUploadMasterList where EmailListID = @LISTID) as S
        on (T.BACKOFFICESYSTEMID = 3 and T.BACKOFFICERECORDID = S.BB_XListRecordID)
        when not matched by target
        then insert (BackOfficeSystemID, BackofficeRecordID) values (3, BB_XListRecordID);

      END