Monday, March 28, 2016

Comma Separated string into individual rows









SELECT A.[State], 
     Split.a.value('.', 'VARCHAR(100)') AS String 
 FROM  (SELECT [State], 
         CAST ('<M>' + REPLACE([City], ',', '</M><M>') + '</M>' AS XML) AS String 
     FROM  TableA) AS A CROSS APPLY String.nodes ('/M') AS Split(a);




No comments:

Post a Comment