Home Forums SQL Server 7,2000 T-SQL Csv list in column to separate columns RE: Csv list in column to separate columns

  • October 1, 2012 at 6:12 pm

    #1544205

    Eliza (9/17/2012)

    Hi all,

    Can I ask please if I have a row and one column has a csv list in it. Is there a way please to split the csv list into columns in a row?

    1. bcp the table to a file.

    2. BULK INSERT from the file to a new table using comma as a delimiter.

    3. Report success. 🙂

    _____________
    Code for TallyGenerator