Copying Data to Table from Restored Table

  • I have an Order table that has an identity seed that I accidentally over wrote a Date entry for every order (3000 of them) I do however have a back up that I restored with all the order dates  except 4 of them. I want to copy over the date in the restored table to the production table. How do I go about doing this? I have tried a copy/paste in EM and that didn't work. Any comments would be really really really appreciated!

  • If this http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=172848 is the same question, please refrain from multiposting. Let's use then the other thread.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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