Append to Existing Table ?

  • What SQLCode with automatically

    APPEND my Item_RTD table to my

    existing Items table since both tables

    have the same 10 digit char fields ?

         SELECT     ID, Item

         FROM         Items

         SELECT     ID, Item

         FROM         Items_RTD

    I tried to do the following, but

    receive a "There is already an object

    named ITEMS in the database." error.

         SELECT     ID, Item

         INTO            Items

         FROM         Items_RTD

  • INSERT INTO Items (ID, Item)

    SELECT ID, Items FROM Items_RTD

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks for the info.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply