SQL Update Query
-
Did not get.
Both statements - my and Mark's - do UPDATE Orders.
What did you mean by "He's updating the OrderDetails table from the Orders table"?
_____________
Code for TallyGenerator -
How long you plan to use this software?
2, 3 years?
Then load 3 years amount of dummy data into database and try to run the application.
Don't sign the project off and don't pay anything to "aforementioned software company" until it works.
_____________
Code for TallyGenerator -
The solutions you guys posted update the ORDER's table from the ORDERDETAILS.
What Mark was doing is the opposite, updateing the ORDER DETAILS table from the ORDER's table. this is why I assumed that the UPDATE FROM method would work.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
C'mon,
everybody forgot about poor Mark!
I don't see anything wrong with your first posting.
Update statement must work fine.
Were there any complaints?
_____________
Code for TallyGenerator
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply