Splitting a CSV demilited Column to rows using DelimitedSplit8K function

• Robert Klimes

  SSCoach

  Points: 17865

  More actions

  July 27, 2011 at 9:57 am

  #1359431

  Check the compatibility level of the database. It worked fine for me until i changed the compatibility level of the database that the function was installed in to sql2000.

  Bob
  -----------------------------------------------------------------------------
  How to post to get the best help[/url]

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  July 27, 2011 at 9:59 am

  #1359434

  Same experience - works fine for me. I would check compat level and service packs.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events