Blog Stats
  • Posts - 14
  • Articles - 0
  • Comments - 14
  • Trackbacks - 0

 

<< Install Visual Studio 2003 when Visual 2005 is intalled already | Home | Pass Multiple values to Modal Window >>

Subquery returned more than 1 value

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

As the error message suggests , this normally occurs when you are assigning a T-SQL variable a value within sql query and the query is returning more that one rows e.g.
Declare @var1 nvarchar(50)
' select @var1=name from table1'

Putting 'top 1' can resolve the problem  in many cases ( do check the business logic aspects):

' select top 1 @var1=name from table1'

Print posted @ Wednesday, February 04, 2009 2:52 PM

Feedback

No comments posted yet.

Post a comment





 

 

 

 

Copyright © faizanahmad