Split one column into multiple rows

by

I think you can do this:

SELECT
    T.id, RIGHT(LEFT(T.csv,Number-1),
    CHARINDEX(',',REVERSE(LEFT(','+T.csv,Number-1))))
FROM
    master..spt_values,
    your_table T
WHERE
    Type="P" AND Number BETWEEN 1 AND LEN(T.csv)+1
    AND
    (SUBSTRING(T.csv,Number,1) = ',' OR SUBSTRING(T.csv,Number,1)  = '')

Code was shamelessly stolen from this site.

More Related Contents:

  1. How to multiply column in Sql
  2. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  3. What is the best way to create and populate a numbers table?
  4. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  5. How do you clear the SQL Server transaction log?
  6. Order Of Execution of the SQL query
  7. SQL Server IN vs. EXISTS Performance
  8. How Can I Log and Find the Most Expensive Queries?
  9. How to drop a table if it exists?
  10. SQL Server truncation and 8192 limitation
  11. Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
  12. How to list all dates between two dates [duplicate]
  13. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  14. Number of times a particular character appears in a string
  15. SQL Server variable columns name?
  16. How to: Create trigger for auto update modified date with SQL Server 2008
  17. SQL Server BCP export corrupted file?
  18. PRINT statement in T-SQL
  19. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  20. What is the point of “Initial Catalog” in a SQL Server connection string?
  21. How can I know when SQL Full Text Index Population is finished?
  22. Avg of float inconsistency
  23. Should I index a bit field in SQL Server?
  24. Setting up maven dependency for SQL Server
  25. Getting a warning when using a pyodbc Connection object with pandas
  26. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  27. How can I get the list of tables in the stored procedure?
  28. How to find the boundaries of groups of contiguous sequential numbers?
  29. In SQL Server, how can I find everywhere a column is referenced?
  30. Convert float into varchar in SQL Server without scientific notation

Leave a Comment