Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. frokka

    Update-copy data between columns

    PHV, thanks for your quick reply, it helped me out :) Allthough I should have told you that I'm using MS T-SQL, which apparently differs from ANSI more than I thought. But I only had to tweak the commands minutely to get it working, here is what I ended up with: UPDATE Table1 SET bb=(SELECT...
  2. frokka

    Update-copy data between columns

    I need to copy data between columns from two identical tables. I want to update rows, not add rows, so it's practically a restore. Table1 contains the columns: aa, bb, cc and Table2 contains the same columns (where aa is the key.) There only difference is the Table1 contains more rows. I'm no...

Part and Inventory Search

Back
Top