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 |
|
pharoah35
Yak Posting Veteran
81 Posts |
 Posted - 2004-08-10 : 09:35:44
|
| Good morningI was hoping you could assist with the following problem. I am trying to impout/update a table with exp dates from one table into another table where the claim number is the same.. Here is the code and the error message..--------------------------------------------------------------------Code:UPDATE dbo.request_headerset dbo.request_header.[gsp_log_no] = dbo.WE.[exp]FROM dbo.request_header INNER JOIN dbo.WE ON dbo.request_header.[claim_no] = dbo.WE.[claim]--------------------------------------------------------------------Error msg:Server: Msg 512, Level 16, State 1, Procedure trg_Status, Line 12Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-10 : 13:12:05
|
| thisdbo.WE.[exp]FROM dbo.request_header INNER JOIN dbo.WE ON dbo.request_header.[claim_no] = dbo.WE.[claim]returns multiple rows, you need to fix it so it will return only one row.Go with the flow & have fun! Else fight the flow :) |
 |
|
|
|
|
|
Help with Import Problem