INSERT INTO [dbo].[ADMIN_Publications_email]
       ([email]
       ,[pmid]
       )
      SELECT @email, CAST(Item AS NVARCHAR(10))
     FROM  dbo.Split(@PMID_List, ',')

DELETE FROM [dbo].[ADMIN_Publications_email]
WHERE (email = @Email) AND IN dbo.Split(@PMID_LIST)

DELETE FROM [dbo].[ADMIN_Publications_email]
WHERE (email = @Email) AND [pmid] IN (SELECT CAST(Item AS NVARCHAR(10)) FROM dbo.Split(@PMID_LIST))

INSERT INTO [dbo].[ADMIN_Publications_email]
       ([email]
       ,[pmid]
       )
      SELECT @email, CAST(Item AS NVARCHAR(10))
     FROM  dbo.Split(@PMID_List, ',')
     WHERE NOT EXISTS
     (
        select 1 from [dbo].[ADMIN_Publications_email] where [email]=@email and [pmid]=CAST(Item AS NVARCHAR(10))
     )