Home Forums SQL Server 2005 T-SQL (SS2K5) Inserting data in one table as selecting from other tables RE: Inserting data in one table as selecting from other tables

  • August 10, 2012 at 5:57 am

    #1524367

    I could not get what you really want but will complete correct sequence for select into..

    Insert into NewTableName(ColumnName1,ColumnName2)

    Select ColumnName1,ColumnName2+ColumnName3 from OldTableName

    If you want Concat of column2 & 3 to be inserted into column2 of new table.