SQL Server 2008 Query (comma separated)

devendar · October 2nd, 2009, 02:42 PM

CREATETABLE #Locations
(Name1 VARCHAR(100))
INSERTINTO #Locations values('Seattle,WA,ABC')
INSERTINTO #Locations values('Chicago,IL,XYZ')

But I want Output like this

City State Name
Seattle WA ABC
Chicago IL XYZ

Thanks in advance,

Old Pedant · October 5th, 2009, 06:49 PM

Code:

CREATE TABLE #Locations
( 
    CityVARCHAR(100),
    State VARCHAR(2),
    Name VARCHAR(100)
)
INSERT INTO #Locations values('Seattle', 'WA', 'ABC')
INSERT INTO #Locations values('Chicago', 'IL', 'XYZ')
...