No announcements
Found 1636293 threads
-
0 Voteswhy this simple query returns no results?
'02.20.2012' THEN 1 ELSE 0 END , CASE WHEN mdeleted is null or mdeleted=0 THEN 1 ELSE 0 END , COUNT(*)FROM ...Answered | 6 Replies | 2670 Views | Created by orlovsn - Wednesday, February 22, 2012 7:45 AM | Last reply by Gert-Jan Strik - Wednesday, February 22, 2012 10:01 PM
-
0 Votes
Simple update but strange results
Best guess is that you have a trigger on the custaddr table and the results being returned are coming from the trigger.Answered | 3 Replies | 1470 Views | Created by Zeddreader - Thursday, February 2, 2012 12:25 AM | Last reply by David Eck - Thursday, February 2, 2012 12:44 AM -
2 Votes
Simple query returns wrong results in Sql 2012
Whenever you get different results from a query depending on whether you have certain indexes in place, you know that the query is indeterministic.Answered | 12 Replies | 3500 Views | Created by Robert Simpson - Monday, January 6, 2014 9:12 PM | Last reply by Robert Simpson - Tuesday, January 7, 2014 5:08 AM -
0 Votes
CAML Query return the duplicate result?
Can you post xml from query ?Answered | 3 Replies | 5654 Views | Created by jdxyw - Tuesday, May 19, 2009 4:13 PM | Last reply by jdxyw - Wednesday, May 20, 2009 5:56 AM -
0 Votes
Query returns incorrect results
The second query will give you both rows with '2013-09-13 00:00:00.000' and '2013-09-13 13:12:00.000'.Answered | 10 Replies | 2859 Views | Created by Lê Thế Anh - Thursday, September 12, 2013 4:23 PM | Last reply by Gert-Jan Strik - Friday, September 13, 2013 5:16 PM -
4 Votes
query and return a result set
It may not be necessary to have a button on the main form and a separate stand-alone form to display the results.Answered | 6 Replies | 4238 Views | Created by meikg - Thursday, June 24, 2010 3:21 PM | Last reply by DenSolis - Friday, June 25, 2010 3:28 AM -
1 Votes
IS NOT NULL causing query to return no results???
It also will return any row with something in region.Answered | 5 Replies | 1965 Views | Created by scheffetz - Friday, July 5, 2013 3:08 PM | Last reply by Jesús López - Friday, July 5, 2013 3:25 PM -
2 Votes
[MDX] Simple query, unexpected results
When you don't specify a specific seller the cube will return the default member which will be "All" - hence the length of 3.Answered | 4 Replies | 1064 Views | Created by Pragmateek - Thursday, October 31, 2019 10:26 AM | Last reply by Pragmateek - Tuesday, November 5, 2019 10:40 AM -
0 Votes
Will these two queries return the same result?
If both of those conditions are true, then the queries will return the same result.Answered | 4 Replies | 661 Views | Created by Gerard_L - Friday, January 20, 2017 3:01 AM | Last reply by Tom Cooper - Friday, January 20, 2017 4:59 AM -
0 Votes
CAML Query not returning all results
I've made some tests recently and the result is...Answered | 9 Replies | 6042 Views | Created by Matt Hill - Wednesday, August 22, 2012 4:06 PM | Last reply by HeToC - Thursday, August 23, 2012 7:03 PM -
2 Votes
Same query returns different result
1" might return more then one row of the same group.Answered | 7 Replies | 10983 Views | Created by Aung Mon Chit Htwe - Monday, July 13, 2015 3:35 AM | Last reply by Conquistador0 - Tuesday, July 14, 2015 9:33 PM -
3 Votes
BCP Query returns NULL result
I have a single client server (first of 43) who have something misconfigured apparently that prevents simple bcp query to execute.Answered | 6 Replies | 3669 Views | Created by Tracy Thomas - Saturday, June 14, 2014 1:53 PM | Last reply by Tracy Thomas - Monday, June 16, 2014 4:18 PM -
0 Votes
Querying AD and returning results in a DataTable
we can do some simple way..Answered | 12 Replies | 16421 Views | Created by SimonR47 - Thursday, April 9, 2009 7:44 PM | Last reply by Vaidees Chandrasekaran - Wednesday, May 30, 2018 11:52 AM -
0 Votes
Incorrect Query Result Set Returned
The generated SQL returns the correct result in SQL Server, but Linq returns a different result.Answered | 6 Replies | 5033 Views | Created by McDaddy98 - Tuesday, November 17, 2009 7:05 PM | Last reply by Michael Sun [MSFT] - Thursday, December 24, 2009 3:57 AM -
0 Votes
CAML Query Returns all results
Hi swalker, Please add <View> tag in CAML Query.Answered | 3 Replies | 899 Views | Created by swalker1522 - Thursday, October 13, 2016 1:08 PM | Last reply by Jerry Zy - Friday, October 14, 2016 7:31 AM -
4 Votes
simple query
this wouldn't be returning the accurate results if there is a case of trailing spaces (as len ignores them).Answered | 3 Replies | 1024 Views | Created by Shruthihc05 - Saturday, February 1, 2014 4:31 AM | Last reply by Jayakumaur (JK) - Sunday, February 2, 2014 6:36 PM -
1 Votes
return query result set from function
Then, to retrieve results as objects, all you need to do is call sqlsrv_fetch_object (note that in my example each result is returned as a stdClass object...you can ...Answered | 1 Replies | 12934 Views | Created by Ken Roberts - Wednesday, July 13, 2011 2:32 AM | Last reply by Brian Swan - MSFT - Wednesday, July 13, 2011 5:53 PM -
0 Votes
Why Does This Query Return Results?
Left Join returns all rows from Left table so that the query is nothing wrong, In case you want to filter the NULL value records for both option1 and option2, use ...Answered | 5 Replies | 840 Views | Created by IndigoMontoya - Monday, February 16, 2015 9:17 PM | Last reply by Aung Mon Chit Htwe - Tuesday, February 17, 2015 1:05 AM -
0 Votes
Strange results using LINQ in PreprocessQuery
Can someone help me rewrite this LINQ to get the result set I'm after?Answered | 6 Replies | 1841 Views | Created by Dr. Dauphin - Monday, August 20, 2012 7:06 PM | Last reply by Dr. Dauphin - Tuesday, August 21, 2012 8:39 PM -
0 Votes
how do I display result of simple datagridview query?
As luck would have it, simple SQL functions allow me to do this, and they all work great within the Query Builder.Answered | 6 Replies | 6092 Views | Created by angus454 - Tuesday, April 17, 2007 3:04 PM | Last reply by Rafael Maya - Wednesday, December 28, 2011 1:57 PM - Items 1 to 20 of 1636293 Next ›
No announcements
