Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

I am hoping someone can explain how to correctly update multiple records in a table using subqueries.

I have one table that 2 fields. The subqueries are returning the correct values for the set and the Where Exists is returning the correct records to update.

any help is greatly appreciated.
UPDATE    TempFinalTubeListMoves
	SET              DestRackRow =
							  (SELECT     TempRecompileLastRackPositions.Row AS DestRackRow
								FROM          TempLastDestRack INNER JOIN
													   TempRecompileLastRackPositions ON TempLastDestRack.Ident = TempRecompileLastRackPositions.Ident INNER JOIN
													   TempFinalTubeListMoves AS TempFinalTubeListMoves ON TempLastDestRack.bc = TempFinalTubeListMoves.bc), 
						  DestRackColumn =
							  (SELECT     TempRecompileLastRackPositions.Col AS DestRackCol
								FROM          TempLastDestRack AS TempLastDestRack INNER JOIN
													   TempRecompileLastRackPositions AS TempRecompileLastRackPositions ON 
													   TempLastDestRack.Ident = TempRecompileLastRackPositions.Ident INNER JOIN
													   TempFinalTubeListMoves AS TempFinalTubeListMoves ON TempLastDestRack.bc = TempFinalTubeListMoves.bc)
	WHERE  EXISTS  
							  (SELECT     *
								FROM          TempLastDestRack AS TempLastDestRack INNER JOIN
													   TempRecompileLastRackPositions AS TempRecompileLastRackPositions ON 
													   TempLastDestRack.Ident = TempRecompileLastRackPositions.Ident INNER JOIN
													   TempFinalTubeListMoves AS TempFinalTubeListMoves ON TempLastDestRack.bc = TempFinalTubeListMoves.bc)

Open in new window

0
TraciShultz
Asked:
TraciShultz
  • 4
1 Solution
 
bull_riderCommented:
Its the same question you are asking again but for different query. Have the answer here:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24405310.html
0
 
bull_riderCommented:
Can you mark it answered here as well?
0
 
bull_riderCommented:
Hi TraciShultz,

Could you please mark this question answered?

Thanks.
0
 
bull_riderCommented:
Please mark the question answered.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now