We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

query list into a string

LeeHopkins
LeeHopkins asked
on
Medium Priority
244 Views
Last Modified: 2010-03-19
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
Comment
Watch Question

do something like this:

declare @list varchar(1000)

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

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

Author

Commented:
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

Author

Commented:
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
declare @list varchar(1000)
select @list = Coalesce(@list + ', ', '') + distinctaddr.p_emailaddress
from (select distinct p_emailaddress from purge_email where charindex('input_output',P_customer)> 0) as distinctaddr
select @list

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.