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 |
|
DURGESH
Posting Yak Master
105 Posts |
 Posted - 2008-06-20 : 23:53:36
|
| HI ALL,GOOD MORNINGI AM GETTING FOLLOWING ERROR WHEN I USED A SELECT STATEMENT TO UPDATE TABLEOnly one expression can be specified in the select list when the subquery is not introduced with EXISTS.CAN ANY HELP ME TO SORT OUT THE ISSUETHANKS IN ADVANCE HAVE A WONDERFUL SATURDAY |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-21 : 01:34:53
|
| You are using a subquery for updation which is returning more than one value that is causing this error. Either post the current code or rewrite it yourself such that it returns a single value per record. Also dont use caps while posting. |
 |
|
|
|
|
|
ERROR WHEN EXECUTING UPDATE QUERY