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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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. -
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... -
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 ?
