SQL Server split CSV into multiple rows

by 
from
    #client_profile_temp cpt
    cross apply dbo.split(
    #client_profile_temp.interests, ',') as split  <--Error is on this line

I think the explicit naming of #client_profile_temp after you gave it an alias is a problem, try making that last line:

    cpt.interests, ',') as split  <--Error is on this line

EDIT You say

I made this change and it didn’t change anything

Try pasting the code below (into a new SSMS window)

create table #client_profile_temp
(id int,
interests varchar(500))

insert into  #client_profile_temp
values
(5, 'Vodka,Potassium,Trigo'),
(6, 'Mazda,Boeing,Alcoa')

select
   cpt.id
  ,split.data
from
    #client_profile_temp cpt
    cross apply dbo.split(cpt.interests, ',') as split

See if it works as you expect; I’m using sql server 2008 and that works for me to get the kind of results I think you want.

Any chance when you say “I made the change”, you just changed a stored procedure but haven’t run it, or changed a script that creates a stored procedure, and haven’t run that, something along those lines? As I say, it seems to work for me.

More Related Contents:

  1. How to get the last row from a table in SQL Server?
  2. Alias name is same as column name [closed]
  3. Understanding PIVOT function in T-SQL
  4. The order of a SQL Select statement without Order By clause
  5. Storing a file in a database as opposed to the file system?
  6. SQL Server named instance with Visual Studio 2017 Installer project
  7. How do you count the number of occurrences of a certain substring in a SQL varchar?
  8. Why is it considered bad practice to use cursors in SQL Server?
  9. Import Excel spreadsheet columns into SQL Server database
  10. CAST and IsNumeric
  11. How do I exclude Weekend days in a SQL Server query?
  12. Best data store for billions of rows
  13. newid() inside sql server function
  14. How can I use a single mssql connection pool across several routes in an Express 4 web application?
  15. When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
  16. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  17. SQL Server 2008 Vertical data to Horizontal
  18. Joining multiple tables returns NULL value
  19. Which join syntax is better?
  20. LPAD in SQL Server 2008
  21. How to maintain the order of insertion in SQL Server
  22. “Prevent saving changes that require the table to be re-created” negative effects
  23. How to change column datatype in SQL Server database without losing data?
  24. What are the differences between Merge Join and Lookup transformations in SSIS?
  25. Convert UTC Milliseconds to DATETIME in SQL server
  26. freeTDS not using its config
  27. @@ERROR and/or TRY – CATCH
  28. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  29. How to make a passthrough / passthru query editable?
  30. Tool for Scripting Table Data

Leave a Comment