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 bkrike 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
Apr 5, 2005
45
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
Working Days giving NULL values
Replies
8
Views
670
Cpreston
Cpreston
kingz2000
  • Locked
  • Question
select data with date condition, choosing latest values from selected dates 2
Replies
16
Views
710
Andrzejek
Andrzejek
scabral1979
  • Locked
  • Question
Aggregate Values By Group
Replies
1
Views
267
imex
imex
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
401
Andrzejek
Andrzejek
Brianfree
  • Locked
  • Question
SQL Rank() But move 0 values to bottom of Rank?
Replies
1
Views
248
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top