split a comma delimited string into columns

• richard.hanby

  Newbie

  Points: 9

  More actions

  August 8, 2018 at 3:01 am

  #2000748

  For anyone stumbling across this post using SQLSERVER 2016+
  From SQL version 13 See this blog post
  https://blog.sqlauthority.com/2018/05/04/sql-server-split-comma-separated-value-string-in-a-column-using-string_split/

  Simply
  SELECT ID, value FROM [YOURTABLE] CROSS APPLY STRING_SPLIT([YOURTABLE].[DELIMITEDCOLUMN], ',')

  For an idea of efficiency 319857 rows in 5 seconds on a 2 core Intel E3v5 12GB ram box, and no SQL injection risk