Rajesh

Wednesday, March 19, 2014

SQL : Split string into Column


 SELECT Split.a.value('.', 'VARCHAR(24)') AS String  
 FROM (SELECT CAST ('<M>' + REPLACE('331AW150A01F01,331AW250A01F01,331AW350A01F01,331WF450A01F01', ',', '</M><M>') + '</M>' AS XML) AS String ) 
 AS A CROSS APPLY String.nodes ('/M') AS Split(a); 

Posted by Rajesh-Ramamoorthy at 11:50 PM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

collegue blog

  • Bala S
  • J Saravanan
  • logesh
  • Manoj HOV
  • poornima
  • shaalini blog

Blog Archive

  • ►  2019 (1)
    • ►  February (1)
  • ►  2017 (1)
    • ►  May (1)
  • ►  2016 (7)
    • ►  October (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
  • ▼  2014 (2)
    • ►  October (1)
    • ▼  March (1)
      • SQL : Split string into Column
  • ►  2012 (16)
    • ►  December (1)
    • ►  April (3)
    • ►  March (1)
    • ►  February (9)
    • ►  January (2)
  • ►  2009 (10)
    • ►  June (4)
    • ►  May (3)
    • ►  April (2)
    • ►  January (1)
  • ►  2008 (35)
    • ►  November (1)
    • ►  September (15)
    • ►  July (19)

About Me

Rajesh-Ramamoorthy
View my complete profile

My hit rate

hit counter
free hit counter
Picture Window theme. Powered by Blogger.