Bulk upsert members from SQL Server
Subscribes or unsubscribes members in bulk using UPSERT INTO ListMembers SOURCE('MSSQL', ...). Data is read from the SQL Server database; result set column names (or aliases) must match ListMembers input columns (e.g. EmailAddress, FirstName, Status). Pass ListId in the WITH clause.
UPSERT INTO ListMembers
SOURCE('MSSQL', 'Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true'
,'select ''brucewayne10@gmail.com'' EmailAddress,''first1'' as FirstName, ''subscribed'' Status
UNION ALL
select ''test55@gmail.com'' EmailAddress,''first1'' FirstName, ''subscribed'' Status
')
WITH(ListId='a4d24015f8')
--//column name alias must match with InputColumns of ListMembers