-- Modified to handle AD Authentication (eg. where the domain is prefixed to the login name but is not stored in the table)

DECLARE @DomainPrefix VARCHAR(MAX) = 'DomainName\' -- ie. Leave blank if SQL authentication
INSERT dbo.tConfig (Key1, Key2, Key3, Key4, Value)
SELECT 'SelectionHistory', 'Synergetic', REPLACE(LoginName,@DomainPrefix,''), 'NeverDeleteLegacyODBC', 'True'
FROM dbo.ConfigUsers cu
WHERE REPLACE(cu.LoginName,@DomainPrefix,'') NOT IN (SELECT REPLACE(cu.LoginName,@DomainPrefix,'') FROM tConfig WHERE Key1 = 'SelectionHistory' AND Key2 = 'Synergetic' AND Key3 = REPLACE(cu.LoginName,@DomainPrefix,'') AND Key4 = 'NeverDeleteLegacyODBC')