No announcements
Found 2727319 threads
-
0 VotesLimit results returned in SQL query
I have been trying to figure out how I can limit the results returned from my query to 10. The only thing I have been able to find is this var ...Answered | 3 Replies | 588 Views | Created by josh.net - Monday, June 9, 2014 6:14 PM | Last reply by Joel Engineer - Tuesday, June 10, 2014 1:05 AM
-
0 Votes
Why doesn't "SET ROWCOUNT" make a difference in Query Cost?
results. While I was testing different versions of the stored proc in Query Analyzer, with Execution Plan turned on, I noticed that limiting the number of rows ...Answered | 1 Replies | 5982 Views | Created by alord1647 - Tuesday, December 12, 2006 2:00 AM | Last reply by Arjun B - Wednesday, December 13, 2006 6:17 AM -
0 Votes
Limit results set in a query?
Hello, Is there a way within the plain search syntax to limit the number of returned rows from a query? Using the WDS front-end the ...Answered | 1 Replies | 7409 Views | Created by David Ing - Thursday, March 16, 2006 2:31 PM | Last reply by Brandon Paddock - Friday, March 17, 2006 6:32 PM -
0 Votes
CQWP Showing Query Returned a Greater Number of Results than the Web Application's Query Throttling Limit
I am creating a content query web part to aggregate documents in document libraries within the site (not site collection). I am receiving this ...Answered | 2 Replies | 3307 Views | Created by obautista - Friday, March 8, 2013 9:44 PM | Last reply by obautista - Monday, March 18, 2013 2:04 PM -
0 Votes
MS SQL server in combination with MS Access
on the wire. If you limit the amount fo results returned by using correct filtering in your WHERE clause then less data will need to be returned and there ...Answered | 1 Replies | 3931 Views | Created by Jordydr - Tuesday, October 18, 2011 6:48 AM | Last reply by Sean Gallardy - Tuesday, October 18, 2011 1:02 PM -
0 Votes
Limit properties returned in queried entities
Is there a way to limit the properties that are returned when doing a query on a container? Currently, it always seems to return the entire XML representation of an ...Answered | 1 Replies | 7385 Views | Created by Ming Lam - Monday, September 22, 2008 5:27 AM | Last reply by Stan Kitsis - MSFT - Monday, September 22, 2008 6:34 AM -
0 Votes
SharePoint Query QueryService() error for number of returned results
. For my query I won't have that many results and hence I changed SOME_NUMBER to 1,000 to get all results (which in reality ... -
0 Votes
SQL Query Results Question
New to using SQL. I don't design queries but run queries that other people design. The results of one query comes out in a divided ...Answered | 2 Replies | 2251 Views | Created by Penguin0227 - Thursday, July 26, 2012 8:44 PM | Last reply by Mike Yin - Thursday, August 2, 2012 12:05 PM -
2 Votes
Locations API : Limit results
service, in which you can set the Count property of the GeocodeOptions of a GeocodeRequest to limit the number of results returned - ...Answered | 4 Replies | 6091 Views | Created by Feather16 - Wednesday, June 29, 2011 6:14 PM | Last reply by Feather16 - Wednesday, July 6, 2011 8:30 PM -
0 Votes
How-To limit returned search results on site collection level?
results page to target a specific Enterprise Search Center which has a hard coded Scope in the Search results web part.Answered | 1 Replies | 1196 Views | Created by Tech-Developer - Sunday, September 7, 2014 7:07 PM | Last reply by Alex Brassington - Sunday, September 7, 2014 9:35 PM -
2 Votes
No results returned from Linq query
" direct in SQL returns the results I expect, and no errors are being generated in Visual Studio when I run the program.Answered | 6 Replies | 733 Views | Created by Tlawrence84 - Saturday, September 20, 2014 6:46 PM | Last reply by Kristin Xie - Tuesday, September 23, 2014 6:51 AM -
1 Votes
not all query results are returned
I am using typed dataset and datadapter.fill method to retrieve data of several tables from SQL server 2008 R2. The data is queried using store procedure, the query is compound ...Unanswered | 3 Replies | 795 Views | Created by NatashD - Thursday, November 6, 2014 6:47 AM | Last reply by Cor Ligthert - Friday, December 5, 2014 3:59 PM -
0 Votes
Query Limit?
Is there a limit to the size of the query for a report? I can create simple reports but when I paste in a larger query (say about 4500 characters and we will ...Unanswered | 1 Replies | 8914 Views | Created by Scott Lezberg - Tuesday, October 25, 2005 6:59 PM | Last reply by F. Dwarf - Friday, January 6, 2006 5:51 AM -
0 Votes
Limit results of people picker query
, can search for users to add to their SharePoint 2013 site, but can only see users that reside within Container A. Unfortunately every attempt we have tried still results ...Unanswered | 1 Replies | 1123 Views | Created by Stephen G_UK - Wednesday, January 18, 2017 2:20 PM | Last reply by Bogdan Coamesu - Sunday, February 5, 2017 7:04 PM -
0 Votes
MDX does not limit results to months in query
I am trying to limit results in an MDX query for specific date ranges. (FY 2017) from 7/1/2016 to 3/31/2017 Even though my ...Answered | 1 Replies | 406 Views | Created by siera_gld - Friday, June 2, 2017 7:42 PM | Last reply by Darren Gosbell - Monday, June 5, 2017 3:24 AM -
0 Votes
Accessing SQL Query Results
get the results from your query there. The results from a query aren't stored in a temp table unless you explicitly set it up that way which sounds beyond ...Answered | 5 Replies | 3119 Views | Created by MonkeyMark - Friday, January 18, 2008 2:27 AM | Last reply by MonkeyMark - Friday, January 18, 2008 4:48 AM -
0 Votes
Limit results in cube
attribute Z slices this 100 to 50. For a select group of users I would like to show the results without attribute Z so the aggregated value of Measure Z would be 50. How ...Answered | 1 Replies | 4951 Views | Created by DanielBos - Tuesday, December 7, 2010 3:08 PM | Last reply by Naveen Das - Tuesday, December 7, 2010 6:27 PM -
0 Votes
Pagination in REST api for Azure Backup
I am trying to get a list of all the "Backup Protected Items" through the Azure Rest Api. In itself the query is working, results are returned. However, ...Answered | 2 Replies | 313 Views | Created by AndrevdG - Wednesday, November 7, 2018 2:47 PM | Last reply by AndrevdG - Friday, November 9, 2018 7:02 AM -
0 Votes
Size of results returned
Is there a way to return the size of a dataset (in bytes) returned by a Log Analytics query? Obviously I can get the Count, but I'm looking for a way to get the ...Proposed | 1 Replies | 251 Views | Created by DolEgon - Monday, February 26, 2018 3:44 PM | Last reply by Stanislav Zhelyazkov - Tuesday, February 27, 2018 6:31 AM -
0 Votes
Flip Query Results in SQL
Is it possible to flip the results returned in a query? Any assistance would be greatly welcomed.Answered | 4 Replies | 5046 Views | Created by tmacdonaldmpower - Wednesday, August 25, 2010 8:10 PM | Last reply by Naomi N - Wednesday, August 25, 2010 10:47 PM - Items 1 to 20 of 2727319 Next ›
No announcements
