SQL Server 2008 - Select distinct names into variable
DECLARE @var VARCHAR(MAX) = '';SELECT @var += x.emailFROM ( SELECT DISTINCT (Email_Username + '@my_email_suffix.com;') as email FROM dbo.My_Table) AS x;SELECT @var;
DECLARE @var VARCHAR(MAX) = '';SELECT @var += x.emailFROM ( SELECT DISTINCT (Email_Username + '@my_email_suffix.com;') as email FROM dbo.My_Table) AS x;SELECT @var;