Need to pivot semi-colon separated names 1

[HoustonGuy]

I have this list:

Name1;Name2;Name3; etc.

And need to write code to pivot it to this:

Name1
Name2
Name3

Any suggestions?

 

[Andrzejek]

Vague question, so one of the answers: replace [tt];[/tt] with Enter / hard return

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[HoustonGuy]

To be more specific, I need to create a column populated with names that are semi-colon delimited.
I do have this, but would like to insert into separate rows into a single column.

DECLARE @TestString varchar(max), @NewString varchar(max)

SET @TestString ='Name1111;Name2;GalvestonIsland;Name3;Name33333;Name444;'
SET @NewString =REPLACE ( @TestString , ';' , CHAR(13) )--hard code a new line feed
PRINT @NewString;

I suspect I'll need to iterate through the string, or use SSIS for a quick load into a table.

 

[simian336]

I am thinking this is a limited example any you want to combine multiple items from a table.

Take a look at FOR XML PATH here in the forums and google

Simi

 

[Andrzejek]

Would these links help?
Turning a Comma Separated string into individual rows
and/or
Splitting delimited values in a SQL column into multiple rows

I just did this

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[HoustonGuy]

Thanks everyone!