No announcements
Found 537157 threads
-
0 VotesSubquery in SQL
Is there anyway can i use SUbquery ??Answered | 6 Replies | 3491 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
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 | 5095 Views | Created by KIRAN KUAMR - Saturday, May 8, 2010 2:31 PM | Last reply by KiranKumar.Y - Saturday, May 8, 2010 7:42 PM -
0 Votes
SubQuery Parmeters
can we use parameter in subquery in SQL Task control like this: select a from (select abc + ?Answered | 4 Replies | 4581 Views | Created by Syed Shahid Hussain - Wednesday, July 21, 2010 10:08 AM | Last reply by Víctor M - Wednesday, July 21, 2010 2:04 PM -
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 | 3665 Views | Created by gk1393 - Wednesday, September 2, 2009 6:28 PM | Last reply by Adam Haines - Wednesday, September 2, 2009 8:08 PM -
2 Votes
Update with Subquery
You cannot do an update with a select subquery in SQL Compact 3.5.Answered | 4 Replies | 9059 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 -
2 Votes
Subquery.
The subquery, "select id from test1" can (and in this case does) return multiple rows.Answered | 3 Replies | 997 Views | Created by H何 - Friday, June 7, 2019 6:28 AM | Last reply by Jingyang Li - Friday, June 7, 2019 2:12 PM -
2 Votes
correlated subquery
Logically, in a correlated subquery, the inner query first evaluate for each row in the outer query.Answered | 7 Replies | 3289 Views | Created by Jeddd - Tuesday, June 5, 2012 10:13 AM | Last reply by Jeddd - Tuesday, June 5, 2012 1:41 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 | 2310 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
Passing parameters to subqueries, VBA
I had used the parameters in both the query and saved subquery.Answered | 4 Replies | 1212 Views | Created by w85 - Monday, August 10, 2015 5:38 PM | Last reply by Edward8520 - Tuesday, August 11, 2015 2:34 AM -
0 Votes
subqueries vs joins
Many Transact-SQL statements that include subqueries can be alternatively formulated as joins.Answered | 12 Replies | 8669 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
Subquery Question
If more than one job was marked as "not-complete", the subquery will fail because multiple rows are returned.Answered | 4 Replies | 7626 Views | Created by FuturShoc - Monday, January 15, 2007 9:21 PM | Last reply by DannoCoy - Tuesday, January 16, 2007 3:49 PM -
0 Votes
Problem with Subquery
Subquery is not required in your case.Answered | 3 Replies | 4521 Views | Created by Manjeet Upadhye - Wednesday, May 11, 2011 10:43 AM | Last reply by --CELKO-- - Wednesday, May 11, 2011 2:24 PM -
0 Votes
Why can this Subquery name be used direct in the Code, by which the Subquery is created?
That's not a subquery, it's a common table expression (CTE).Answered | 1 Replies | 590 Views | Created by mianin - Tuesday, November 24, 2015 4:18 PM | Last reply by Patrick Hurst - Tuesday, November 24, 2015 4:23 PM -
0 Votes
Subquery Question
The reason was i am just practicing the subquery .Answered | 11 Replies | 3273 Views | Created by Palle Technologies - Friday, May 4, 2012 10:39 AM | Last reply by Palle Technologies - Saturday, May 5, 2012 2:26 AM -
0 Votes
Subquery returned more than 1 value.
Typically the sub-query needs to be written as (SELECT TOP 1 <whatever>) - generally an ORDER BY clause is included so that if there are multiple values returned, the desired value ...Answered | 7 Replies | 9426 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
Having subqueries within select statements
If the subquery table is with limited records (less than 100 or so) AND there only one column to be selected from that lookup table, then I would rather go for the subquery ...Answered | 3 Replies | 4409 Views | Created by MrFlinstone - Thursday, September 16, 2010 10:06 AM | Last reply by Atif-ullah Sheikh - Thursday, September 16, 2010 10:59 AM -
2 Votes
Year Value in Subquery
Thanks Sir Tom for the explanation i really appreciate it. i think now i understand how to use SubQuery :)Answered | 8 Replies | 1782 Views | Created by jefnavarro - Monday, November 12, 2012 5:30 AM | Last reply by Ahsan Kabir - Monday, November 12, 2012 7:56 AM -
0 Votes
Need your help with the subquery
In this subquery you're missing the FROM clause and also why do you need it?Answered | 4 Replies | 1804 Views | Created by Jeremiah L - Thursday, May 9, 2013 3:29 PM | Last reply by Jeremiah L - Thursday, May 9, 2013 5:30 PM -
0 Votes
Best use of Correlated subquery in sqlserver
Examples include EXISTS(), IN(), and SELECT (SELECT ...)Answered | 5 Replies | 8945 Views | Created by Chaithanya Reddy - Tuesday, December 20, 2011 6:11 AM | Last reply by SIVA0 - Saturday, March 4, 2017 5:16 PM -
2 Votes
Subquery returned
Hi, The subquery i can see in the starting is ( SELECT DT FROM MFI_SYS WHERE SYS_CD = 'LAST_COMP_DATE' ) May be this one ...Answered | 6 Replies | 3559 Views | Created by Farhan1 - Tuesday, February 28, 2012 12:27 AM | Last reply by --CELKO-- - Tuesday, February 28, 2012 2:51 AM - Items 1 to 20 of 537157 Next ›
No announcements
