Home Forums SQL Server 2005 T-SQL (SS2K5) I need the code part for splitting the row into different columns? RE: I need the code part for splitting the row into different columns?

  • April 9, 2013 at 12:49 am

    #1604681

    andrewalex.r (4/8/2013)

    Company_ID Employee_ID In_Time Out_Time Remarks Entry_Date

    17921Task Completed 2013-04-08

    181022Good 2013-04-08

    19819Not Bad 2013-04-08

    110718Bad 2013-04-08

    111921Excellent 2013-04-08

    112724Task Completed 2013-04-08

    113823In Progress 2013-04-08

    Are you saying that the first post shows a single row (in a text file?) and that you want to create a text file that looks like this?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.