No announcements
Found 3309268 threads
-
0 VotesDynamically order by not working for all the page in SSRS
Hi, This is my first time in microsoft forum. Currently I am working on SSRS report using MDX. I was trying to do Order by dynamically on report. So ...Answered | 1 Replies | 4538 Views | Created by Jhony das - Friday, December 17, 2010 10:06 PM | Last reply by gk1393 - Saturday, December 18, 2010 3:26 AM
-
0 Votes
sql server r2 Order By class not working
plan_name IN (' + STUFF(REPLACE(@columns, ', p.[', ',['), 1, 1, '') + ') ) AS p;'; print @sql EXEC sp_executesql @sql; i want to order by ...Answered | 2 Replies | 1 Views | Created by Anonymous - Wednesday, June 25, 2014 3:17 AM | Last reply by Anonymous - Wednesday, June 25, 2014 9:05 AM -
1 Votes
Changing Order By in subform not working as expected
; The debug.print indicates the order by is being changed but the order of the records displayed does not change. It is as if the requery ...Answered | 1 Replies | 7037 Views | Created by Steve Staab - Wednesday, April 20, 2011 4:13 AM | Last reply by AccessVandal - Wednesday, April 20, 2011 4:33 AM -
0 Votes
Order By SQL Statement Not Working
(replace(replace(replace(replace(carno,'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9',''),'0','') from caraccount order by carno ASCAnswered | 14 Replies | 44 Views | Created by Anonymous - Saturday, October 20, 2007 8:45 AM | Last reply by Anonymous - Monday, October 22, 2007 10:10 PM -
0 Votes
fill listview calling a Stored Procedure with ORDER BY not working
" So the ORDER BY of the SP is not used. It's not a local db. The listview's Sort property is set to None and never ...Answered | 11 Replies | 1861 Views | Created by candide - Tuesday, October 6, 2015 11:48 AM | Last reply by candide - Wednesday, October 7, 2015 12:10 PM -
3 Votes
C# LINQ order by not working for a SQL table with a primary key
Hi, Hi I tried your statement and unfortunately it does not solve the problem. I always get the list in the ascending order of the primary key ...Answered | 7 Replies | 7815 Views | Created by Clive2334 - Monday, November 5, 2012 6:09 AM | Last reply by Clive2334 - Monday, November 5, 2012 7:26 AM -
0 Votes
Order By Date Not Working First 10 Record ?
User-595703101 posted Hi Jayraj, The Row_Number() function runs over REGID field not on date column So on the first page the first 10 ...Answered | 2 Replies | 1 Views | Created by Anonymous - Wednesday, September 4, 2013 8:33 AM | Last reply by Anonymous - Wednesday, September 4, 2013 10:15 AM -
0 Votes
Order By is not working with the character 'Aa'
Hi, When I am using the Order By in the sql query with character 'Aa', then its not showing in the sorting order place. Its ...Answered | 2 Replies | 1884 Views | Created by Jineesh JM - Monday, November 4, 2013 7:47 AM | Last reply by Allen Li - MSFT - Tuesday, November 5, 2013 1:46 AM -
0 Votes
SPQuery with Order By is not working properly
Hi i have document library having custom column named INDEX of type Number and ...Answered | 1 Replies | 1227 Views | Created by Kaushal Khamar - Monday, March 27, 2017 6:30 AM | Last reply by Kaushal Khamar - Monday, March 27, 2017 11:53 AM -
0 Votes
My ORDER BY CASE is not working. Can anyone help?
User-1369841883 posted Strange as it seems, that did not work. Everywhere I looked said that "ORDER BY CASE WHEN @variable = '' THEN" or ...Answered | 17 Replies | 4 Views | Created by Anonymous - Tuesday, January 18, 2011 9:30 PM | Last reply by Anonymous - Thursday, January 20, 2011 12:06 PM -
0 Votes
Order by is not working when having two fields: double and string
worked but as soon as I set both fields the result from the search is sorted just by the listPrice. I tested my query using search explorer thinking that the C# wrapper ...Answered | 3 Replies | 501 Views | Created by Allan.Paramo - Thursday, December 29, 2016 7:42 PM | Last reply by Bruce Johnston - MSFT - Tuesday, January 3, 2017 6:21 PM -
0 Votes
SQL-Order by clause not working
i right ? "INSERT queries that use SELECT with ORDER BY to populate rows guarantees how identity values are computed but not the order in ...Proposed | 5 Replies | 6134 Views | Created by Rihan8585 - Wednesday, March 6, 2013 1:11 PM | Last reply by Dinesh Kumar Rajendran - Thursday, March 7, 2013 10:27 AM -
0 Votes
Order by Datetime field is not working
User77042963 posted DO you have an Identity field for your table: If you have, try this: ...ORDER BY yourDateTime, ...Answered | 6 Replies | 7 Views | Created by Anonymous - Thursday, July 9, 2009 10:02 AM | Last reply by Anonymous - Thursday, July 9, 2009 11:34 AM -
0 Votes
Order by in select statement not working
, should have checked the syntax properly. You need to make the order by part of the string being built. Me.companyname.RowSource = "SELECT [companyname] FROM ...Answered | 5 Replies | 4034 Views | Created by RhysDavies - Monday, December 18, 2006 8:38 AM | Last reply by RhysDavies - Monday, December 18, 2006 11:57 AM -
0 Votes
Sorting Order Desc by Date with Amount not working.
Hi Nijojo, If I understand correctly you would like to order based on the dates and not based on the measure. Your example will shoe the highest measure ...Answered | 3 Replies | 4420 Views | Created by nijojo - Tuesday, March 10, 2009 4:53 AM | Last reply by Mahesh_Hegde - Tuesday, March 10, 2009 8:58 AM -
0 Votes
Select top 3 not working when Order by Desc
be the problem? Thanks SELECT TOP 3 PR_Headline FROM pressRelease WHERE (((pressRelease.LeftRight)=1) AND ...Answered | 1 Replies | 2 Views | Created by Anonymous - Monday, January 21, 2008 10:15 PM | Last reply by Anonymous - Monday, January 21, 2008 10:57 PM -
0 Votes
Linq Order By DateTime does not seem to be working...
If objects in the list are type of DateTime, they should sort correctly. If they are strings, the dates will be orders by the chars in order like ...Answered | 4 Replies | 30245 Views | Created by Deepak Vasudevan - Monday, February 18, 2013 3:01 PM | Last reply by Mitja Bonca - Monday, February 18, 2013 4:46 PM -
5 Votes
ORDER BY and CASE statement not working with VARCHAR types
You need to use the same expression I posted in the ROW_NUMBER() ORDER BY clause, e.g. DECLAREAnswered | 13 Replies | 9356 Views | Created by Maximusdm - Wednesday, May 18, 2011 8:39 PM | Last reply by Maximusdm - Friday, May 20, 2011 4:53 PM -
0 Votes
Encrypted columns not working with ISNULL and order by clause
I don't know how it executes internally, but I got the order by working with the TOP clause.Answered | 9 Replies | 4015 Views | Created by ABC30 - Tuesday, October 31, 2017 10:36 AM | Last reply by ABC30 - Wednesday, November 8, 2017 7:29 AM -
0 Votes
Order by most recent date not working in CAML Query
string.concat like so and check for a boolean value of 1 not ...Answered | 5 Replies | 6476 Views | Created by Sherazad - Tuesday, June 10, 2014 7:40 PM | Last reply by Sherazad - Thursday, June 19, 2014 2:34 PM
No announcements
