Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexP
Starting Member
34 Posts |
 Posted - 2005-07-20 : 09:30:50
|
| ok guys here is one for you.Simply said I am select certain rows including an OrderID field from several tables and bringing back a result set.How can I update the bOrderSubmitted field for each record that has been retrieved? Can I do it in the same SQL statement?Thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-20 : 09:39:01
|
| Post table structures with sample and expected resultMadhivananFailing to plan is Planning to fail |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-07-20 : 09:43:19
|
| You can't perform an UPDATE and a SELECT in the same statment. They need to be 2 seperate statements.Be One with the OptimizerTG |
|
|
|
AlexP
Starting Member
34 Posts |
Posted - 2005-07-20 : 14:38:38
|
| yes thanks that is what I did ,TG. |
|
|
|
|
|
|
Update Records After an Insert