No announcements
Found 470428 threads
-
0 Votesworking of aggregrate in subquery using exists
But now, your are putting this in a WHERE EXISTS, so you have where exists( select count(1) from <some table> where <some ...Answered | 7 Replies | 811 Views | Created by AniketDeshmukh - Tuesday, August 4, 2015 2:42 PM | Last reply by AniketDeshmukh - Friday, August 14, 2015 2:44 AM
-
0 Votes
Replace SQL Subqueries with EXISTS
EXISTS is a boolean expression and cannot be used to simply replace a subquery that generates a derived table.Answered | 2 Replies | 4724 Views | Created by pyelpo - Thursday, July 28, 2011 2:07 PM | Last reply by --CELKO-- - Thursday, July 28, 2011 10:17 PM -
1 Votes
IF EXISTS in a SELECT subquery??
If you need some logic based on existence, then, as I said: select ..., case when exists (select 1 from myTable T1 where t1.myID = T.MyID) then ...Answered | 29 Replies | 9186 Views | Created by maybush1 - Thursday, July 15, 2010 2:21 PM | Last reply by Naomi N - Thursday, July 15, 2010 7:02 PM -
1 Votes
Query with inequality and NOT EXISTS yields " Subquery returned more than 1 value"
I get Subquery returned more than 1 value.Answered | 4 Replies | 3147 Views | Created by jZe - Wednesday, November 2, 2011 7:20 PM | Last reply by TiborK - Wednesday, November 2, 2011 8:07 PM -
2 Votes
Subquery.
The subquery, "select id from test1" can (and in this case does) return multiple rows.Answered | 3 Replies | 1121 Views | Created by H何 - Friday, June 7, 2019 6:28 AM | Last reply by Jingyang Li - Friday, June 7, 2019 2:12 PM -
0 Votes
Subquery Question
If more than one job was marked as "not-complete", the subquery will fail because multiple rows are returned.Answered | 4 Replies | 7711 Views | Created by FuturShoc - Monday, January 15, 2007 9:21 PM | Last reply by DannoCoy - Tuesday, January 16, 2007 3:49 PM -
1 Votes
Exists operator returns unexpected result when using subquery
The problem is that existing does not return the expected values when using the subquery or subcubes.Answered | 1 Replies | 3493 Views | Created by Tomer D - Monday, October 3, 2011 8:41 PM | Last reply by Deepak Puri - Monday, October 3, 2011 10:22 PM -
0 Votes
subquery
Hi Kumar, Actually there is no such concept in sql server 2005 in built and as far I know Parameterized subquery is just like your normal query where you ...Answered | 1 Replies | 5194 Views | Created by KIRAN KUAMR - Saturday, May 8, 2010 2:31 PM | Last reply by KiranKumar.Y - Saturday, May 8, 2010 7:42 PM -
2 Votes
Update with Subquery
You cannot do an update with a select subquery in SQL Compact 3.5.Answered | 4 Replies | 9170 Views | Created by Giovanni A. Costa Rosa - Wednesday, January 31, 2007 6:02 PM | Last reply by ErikEJ - Thursday, April 23, 2009 6:24 PM -
0 Votes
Subquery returned more than 1 value.
Since the error explicitely says the problem is in a subquery, as already said by Erland Sommarskog, an EXISTS clause may be the culprit.Answered | 7 Replies | 9550 Views | Created by SQL Learner 2015 - Friday, December 4, 2015 3:32 PM | Last reply by AbsolutelyFreeWeb - Monday, December 7, 2015 1:27 AM -
0 Votes
correlated subquery vs tables
Hi arkiboys, From my side, I don't think tables can be used to replace the correlated subqueries.Answered | 5 Replies | 1065 Views | Created by arkiboys - Tuesday, December 8, 2015 2:57 PM | Last reply by Martin.Cairney - Wednesday, December 9, 2015 5:21 AM -
0 Votes
Subquery in SQL
Is there anyway can i use SUbquery ??Answered | 6 Replies | 3606 Views | Created by Jeevan Dasari - Wednesday, May 30, 2012 2:01 AM | Last reply by Naomi N - Wednesday, May 30, 2012 2:19 AM -
0 Votes
Stored Procedure Subquery Issue
another reason might be as Sommarskog said, can you also check any triggers exists on the detailstbl and maintbl??Answered | 8 Replies | 7377 Views | Created by obrienkev - Friday, September 10, 2010 1:42 PM | Last reply by Jon Royales - Friday, September 10, 2010 4:02 PM -
0 Votes
Error on Subquery
I also tried IN before, got the same error: Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value.Answered | 7 Replies | 2408 Views | Created by Sta Horse - Friday, September 21, 2012 6:20 AM | Last reply by S_Surve - Monday, September 24, 2012 5:25 AM -
0 Votes
Best use of Correlated subquery in sqlserver
Examples include EXISTS(), IN(), and SELECT (SELECT ...)Answered | 5 Replies | 9028 Views | Created by Chaithanya Reddy - Tuesday, December 20, 2011 6:11 AM | Last reply by SIVA0 - Saturday, March 4, 2017 5:16 PM -
3 Votes
Please help, error: Subquery returned more than 1 value.
This is not permitted when the subquery follows =, !Answered | 7 Replies | 10446 Views | Created by dudskie - Friday, August 19, 2011 4:57 AM | Last reply by Rishabh K - Friday, August 19, 2011 6:06 AM -
0 Votes
Subquery error?
Hi Kumar, As said by Brad, If you want to have output using a subquery you can but if you are selecting it with other columns and the subquery returns multiple ...Answered | 5 Replies | 3768 Views | Created by gk1393 - Wednesday, September 2, 2009 6:28 PM | Last reply by Adam Haines - Wednesday, September 2, 2009 8:08 PM -
3 Votes
Column selected in Subquery does not exist, but query does not fail or return error.
In any event, the current 2008 BOL does document how unqualified column names in the subquery are resolved.Answered | 3 Replies | 3802 Views | Created by Andre Mathee - Wednesday, September 14, 2011 12:04 PM | Last reply by Naomi N - Wednesday, September 14, 2011 3:05 PM -
0 Votes
subqueries vs joins
From BOL "Subquery Fundamentals" A subquery is also called an inner query or inner select, while the statement containing a ...Answered | 12 Replies | 8791 Views | Created by ShivYorker - Monday, September 12, 2011 10:25 AM | Last reply by gao.seng - Thursday, September 22, 2011 2:54 PM -
0 Votes
Problem with Subquery
Subquery is not required in your case.Answered | 3 Replies | 4618 Views | Created by Manjeet Upadhye - Wednesday, May 11, 2011 10:43 AM | Last reply by --CELKO-- - Wednesday, May 11, 2011 2:24 PM - Items 1 to 20 of 470428 Next ›
No announcements
