Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-05-13
4
Medium Priority
?
399 Views
Last Modified: 2012-05-06
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
Comment
Question by:TraciShultz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
4 Comments
 
LVL 6

Expert Comment

by:bull_rider
ID: 24381324
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
 
LVL 6

Expert Comment

by:bull_rider
ID: 24381385
Can you mark it answered here as well?
0
 
LVL 6

Expert Comment

by:bull_rider
ID: 24381643
Hi TraciShultz,

Could you please mark this question answered?

Thanks.
0
 
LVL 6

Accepted Solution

by:
bull_rider earned 2000 total points
ID: 24387085
Please mark the question answered.
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question