<div>
do something like this:<br />
<br />
declare @list varchar(1000)<br />
<br />
select @list = @list + emailaddress + ';' from table1<br />
<br />
set @list = substring(@list,1, (len(@list) - 1))
</div>


do something like this:

declare @list varchar(1000)

select @list = @list + emailaddress + ';' from table1

set @list = substring(@list,1, (len(@list) - 1))

<div>
no go<br />
<br />
declare @list varchar(1000)<br />
<br />
select @list = @list + p_emailaddress + ';' from Purge_Email<br />
<br />
set @list = substring(@list,1, (len(@list) - 1))<br />
<br />
it should have returned 4 records<br />

</div>


no go

declare @list varchar(1000)

select @list = @list + p_emailaddress + ';' from Purge_Email

set @list = substring(@list,1, (len(@list) - 1))

it should have returned 4 records


<div>
declare @list varchar(1000)<br />
select @list = Coalesce(@list + ', ', '') + p_emailaddress<br />
from purge_email where charindex('input_output',P<wbr />_customer)<wbr />&gt; 0<br />
select @list<br />
<br />
Almost works but not giving distinct
</div>


declare @list varchar(1000)
select @list = Coalesce(@list + ', ', '') + p_emailaddress
from purge_email where charindex('input_output',P_customer)> 0
select @list

Almost works but not giving distinct

<div>
<div class="content wysiwyg-content">
I have a query that brings back a list of email address based on some factor I need to creat a list<br />
x@.com;y@.com;z@.com......<wbr />..<br />
from a result set<br />
x@.com<br />
y@.com<br />
z@.com<br />
......<br />
with out haveing to do a cursor
</div>
</div>


I have a query that brings back a list of email address based on some factor I need to creat a list
x@.com;y@.com;z@.com........
from a result set
x@.com
y@.com
z@.com
......
with out haveing to do a cursor

query list into a string

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.