No announcements
Found 115322 threads
-
0 VotesDAX Subquery
You mentioned there is not much we can't do in DAX but I still couldn't find how I can use subquery in DAX.Answered | 5 Replies | 4550 Views | Created by AL.M - Thursday, November 12, 2015 11:06 PM | Last reply by Darren Gosbell - Monday, November 16, 2015 10:40 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 | 4908 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 | 8843 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 | 765 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 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 | 3492 Views | Created by gk1393 - Wednesday, September 2, 2009 6:28 PM | Last reply by Adam Haines - Wednesday, September 2, 2009 8:08 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 | 2101 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
Subquery returned more than 1 value.
I got an Invalid column name 'StudentId'. error at the end of the code (rs on rs.StudentId=st.StudentId) how ever I want to update all the records ...Answered | 4 Replies | 3079 Views | Created by cuccisima - Tuesday, December 13, 2011 1:12 PM | Last reply by cuccisima - Tuesday, December 13, 2011 2:12 PM -
0 Votes
Subquery inside an IN Statement
Your first example is a scalar subquery, which is cast to a scalar value (if it were empty, it would be cast to a NULL)./ Your second example is a tabular ...Answered | 9 Replies | 1697 Views | Created by Scott_Hanebutt - Friday, September 28, 2012 11:52 AM | Last reply by --CELKO-- - Friday, September 28, 2012 2:45 PM -
0 Votes
Subquery in SQL
Is there anyway can i use SUbquery ??Answered | 6 Replies | 3241 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
Problem with Subquery
Subquery is not required in your case.Answered | 3 Replies | 4332 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
Subquery Question
If more than one job was marked as "not-complete", the subquery will fail because multiple rows are returned.Answered | 4 Replies | 7479 Views | Created by FuturShoc - Monday, January 15, 2007 9:21 PM | Last reply by DannoCoy - Tuesday, January 16, 2007 3:49 PM -
0 Votes
Subquery Question
The reason was i am just practicing the subquery .Answered | 11 Replies | 3079 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 Parmeters
can we use parameter in subquery in SQL Task control like this: select a from (select abc + ?Answered | 4 Replies | 4414 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 -
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 | 3395 Views | Created by Farhan1 - Tuesday, February 28, 2012 12:27 AM | Last reply by --CELKO-- - Tuesday, February 28, 2012 2:51 AM -
0 Votes
Passing parameters to subqueries, VBA
I had used the parameters in both the query and saved subquery.Answered | 4 Replies | 970 Views | Created by w85 - Monday, August 10, 2015 5:38 PM | Last reply by Edward8520 - Tuesday, August 11, 2015 2:34 AM -
2 Votes
named Calculation-Subqueryissue
There are many ways however the problem you are experincing is due to what you are trying to do in a named calculation dimension.Answered | 10 Replies | 6476 Views | Created by Yuvaraj.S - Friday, May 13, 2011 6:43 AM | Last reply by Yuvaraj.S - Friday, May 13, 2011 10:23 AM -
1 Votes
not like with subquery
Hello, how can I use not like with Select statement in a subquery?Answered | 3 Replies | 2338 Views | Created by Amit_kala - Thursday, November 22, 2012 6:11 AM | Last reply by Amit_kala - Thursday, November 22, 2012 9:58 AM -
0 Votes
How to reuse subquery ?
The output and your 'reusing' the subquery statement doesnot match.Answered | 3 Replies | 2815 Views | Created by Hemkoe - Wednesday, July 29, 2015 7:47 PM | Last reply by Eric__Zhang - Thursday, July 30, 2015 7:50 AM -
0 Votes
Reference a column in subquery
Scope of subquery is limited inside the subquery itself until and unless you defined it in FROM clause.Answered | 1 Replies | 5477 Views | Created by JohnTerrance - Monday, May 11, 2009 12:55 PM | Last reply by Mangal Pardeshi - Monday, May 11, 2009 12:59 PM -
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 | 786 Views | Created by arkiboys - Tuesday, December 8, 2015 2:57 PM | Last reply by Martin.Cairney - Wednesday, December 9, 2015 5:21 AM - Items 1 to 20 of 115322 Next ›
No announcements
