Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenating Values

Status
Not open for further replies.
dpgirl

dpgirl

Technical User
Joined
Apr 5, 2005
Messages
45
Location
US
Here's my sample data:

Campaign Market
1 Los Angeles
1 New Orleans
1 St. Louis
2 Orlando
2 Seattle

I want to create a temporary table which will only have one record per Campaign value. All the Market values corresponding to that campaign will be combined into one string, separated by commas.

My desired result:

Campaign Market
1 Los Angeles, New Orleans, St. Louis
2 Orlando, Seattle
 
Sort by date Sort by votes
Look here: thread183-1159740

Post back here if you have any followup questions.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question Question
Working Days giving NULL values
Replies
8
Views
937
Cpreston
Cpreston
kingz2000
  • Locked
  • Question Question
select data with date condition, choosing latest values from selected dates
Replies
16
Views
1K
Andrzejek
Andrzejek
scabral1979
  • Locked
  • Question Question
Aggregate Values By Group
Replies
1
Views
405
imex
imex
bmacbmac
  • Locked
  • Question Question
Inserting XML data into SQLServer returns only NULL values
Replies
3
Views
547
Andrzejek
Andrzejek
Brianfree
  • Locked
  • Question Question
SQL Rank() But move 0 values to bottom of Rank?
Replies
1
Views
336
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top