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. Talnaus

    Selecting from one field then updating into another

    Ah, thanks, didnt realize that till you mentioned it i removed the unique constraint and it worked.
  2. Talnaus

    Selecting from one field then updating into another

    OK i got it to update one row at a time like update tblFPPets set AcctNum = LicenseNum, LicenseNum = null where DateLicenseExpires < getdate() and OwnerID_FK = 8 but when i try to do it on the entire database like update tblFPPets set AcctNum = LicenseNum, LicenseNum = null where...
  3. Talnaus

    Selecting from one field then updating into another

    I am trying to select data from one field and updating it into a different field thats in the same row. But i dont really know where to begin since im new to SQL, i know i got to start with a select but how to i then use that to update into the other field ?

Part and Inventory Search

Back
Top