Home Forums SQL Server 2005 T-SQL (SS2K5) inserting horizontal records from table1 as vertical records in table2 RE: inserting horizontal records from table1 as vertical records in table2

  • July 15, 2013 at 2:59 am

    #1632358

    HanShi (7/15/2013)

    INSERT INTO table2

    SELECT FDT1 TODT1 FROM table1

    UNION ALL

    SELECT FDT2 TODT2 FROM table1

    I think you might need to add a comma between the column names ...

    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.