denormalize select statement help

Question

denormalize select statement help

peygham

Right there with Babe

Points: 757
More actions
August 11, 2008 at 9:21 am

#71802

Hello All,
I have the following;
Table1
Name County
A Adair
B Adair
C Adair
D Orange
E Orange
etc...
what I want is the following;
Name County
A, B ,C Adair
D, E Orange
etc...
I do appreciate any and all suggestions.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Check out this article: http://www.sqlservercentral.com/articles/tamestrings6/263/

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

peygham Right there with Babe Points: 757 More actions · Answer 2

peygham

Right there with Babe

Points: 757

August 11, 2008 at 11:25 am

#856271

Thank you. That worked.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

You might also be interested in some of the pitfalls of concatenation code...

http://www.sqlservercentral.com/articles/Test+Data/61572/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

karthik M One Orange Chip Points: 29139 More actions · Answer 4

Thank you. That worked.

Good. Which method you have used to accomplish your task ?

karthik

peygham Right there with Babe Points: 757 More actions · Answer 5

I used the following;

declare @r varchar( 255), @C varchar( 255)

select @r = substring( recipients, 1, charindex( ';', recipients)-1),

@C = substring( recipients, charindex( ';', recipients)+1, 255)

from email_notification

where process='Business Process 1'

select @r, @C

I've not tried the second one yet.