title: Alternative for String_split in SQL Server
body: <pre><code>WITH dataforIDs AS
  (
      SELECT 
          value, ERSBusinessLogic_InputDataSeries
      FROM 
          [AnimalProductsCoSD].[CoSD].[ERSBusinessLogic]
      CROSS APPLY 
          STRING_SPLIT(ERSBusinessLogic_InputDataSeries, ',')
      WHERE 
          ERSBusinessLogic_InputGeographyDimensionID = 7493
          AND ERSBusinessLogic_InputTimeDimensionValue = 'all months'
          AND ERSBusinessLogic_Type = 'HS10 aggregation'
   )
  </code></pre>
  
  <p>Now I use this query to split the column ERSBusinessLogic_InputDataSeries which is comma separated, but I need to set the compatibility_level to 140. I need an alternative as this will run on the server and I cannot change it explicitly there.</p>