No announcements
Found 858532 threads
-
0 VotesOleDbCommand Order ASC within a group
Actually I want an order within an order: "SELECT [Grp], [Nr] FROM [MyTable] ORDER BY [Grp] ASC, [Nr] ...Answered | 2 Replies | 72 Views | Created by Anonymous - Saturday, April 9, 2016 5:35 PM | Last reply by Anonymous - Saturday, April 9, 2016 6:24 PM
-
0 Votes
Order by Caps first and order by asc
0 drop table #test create table #test(id int identity(1,1),job_title varchar(100)) insert into #test select 'Account Relations Liaison' union select 'Account Relations ...Answered | 7 Replies | 1169 Views | Created by Ganesh Babu - Thursday, January 9, 2014 8:03 PM | Last reply by Ganesh Babu - Thursday, January 9, 2014 10:23 PM -
1 Votes
Understanding the MDX order function - ASC and BASC
1) I now understand the distinction between ASC and BASC.Answered | 2 Replies | 6889 Views | Created by StJohn Kettle - Thursday, September 8, 2011 11:33 PM | Last reply by StJohn Kettle - Sunday, September 11, 2011 1:29 AM -
1 Votes
ASC order on department name and person name in MDX
[Employee].currentmember.member_name select {} on 0,order([Department].Answered | 3 Replies | 2889 Views | Created by Manjunath Jogin - Wednesday, September 11, 2013 12:17 PM | Last reply by Manjunath Jogin - Friday, September 13, 2013 6:58 AM -
0 Votes
Is there a way to change order in an Order by statement to be something other than asc or desc?
Extensions are created to be used in the software environment in order to facilitate utility.Answered | 7 Replies | 4357 Views | Created by agentf1 - Tuesday, February 3, 2009 7:39 PM | Last reply by gvee - Tuesday, February 10, 2009 4:29 PM -
2 Votes
How to make "order by asc or desc", based on values ?
SELECT * FROM Product ORDER BY CASE Quantity WHEN 0 THEN 0 ELSE 1 END DESC, Quantity Please let me know if this doesn’t work ...Answered | 6 Replies | 5623 Views | Created by Alex Q8 - Thursday, May 26, 2011 7:13 AM | Last reply by Gert-Jan Strik - Thursday, May 26, 2011 5:00 PM -
0 Votes
We can ORDER BY ASC but NOT BY DESC, has no sense!
Order by does support DESC - see here: https://www.documentdb.com/sql/demo You are hitting a known issue around ORDER BY where one or more of the first ...Answered | 1 Replies | 642 Views | Created by jamesjara - Tuesday, October 13, 2015 8:44 PM | Last reply by Kirat Pandya [Msft] - Friday, October 16, 2015 6:14 PM -
1 Votes
Concatenate Values in ASC,DESC
ORDER BY n DESC ...Answered | 3 Replies | 910 Views | Created by HarshaV - Wednesday, December 30, 2015 10:41 PM | Last reply by HarshaV - Thursday, December 31, 2015 10:02 PM -
2 Votes
Parameter-driven ASC/DESC Sort?
try this, DECLARE @SortDesc bit = 1; IF @SortDesc = 1 SELECT * FROM Sales.SalesOrderHeader ORDER BY SalesOrderID DESC ELSE SELECT * FROM Sales.SalesOrderHeader ...Answered | 5 Replies | 13933 Views | Created by Kalman Toth - Sunday, August 11, 2013 7:42 PM | Last reply by Kalman Toth - Monday, August 12, 2013 6:56 AM -
0 Votes
execution order - group by and order by
BOL: "Logical Processing Order of the SELECT statement The following steps show the logical processing order, or binding order, for a ...Answered | 3 Replies | 1588 Views | Created by Swapa9 - Saturday, December 14, 2013 6:02 PM | Last reply by Kalman Toth - Saturday, December 14, 2013 6:22 PM -
0 Votes
Linq to Entities 4.1 - Group query forces ordering
Because Groupby will give the resultset a default order, the we use Orderby, it will override the order of the result based on our requirment.Answered | 1 Replies | 3402 Views | Created by Arthununesq - Thursday, June 9, 2011 6:06 PM | Last reply by Jackie-Sun - Monday, June 13, 2011 8:33 AM -
0 Votes
Add Group within a Group?
Only active directory groups can be nested, SharePoint groups cannot be.Answered | 3 Replies | 3941 Views | Created by Check'on'it - Tuesday, June 19, 2012 5:43 AM | Last reply by Check'on'it - Tuesday, June 19, 2012 6:11 AM -
0 Votes
Problem due to 2nd OleDbCommand
Elmar already added a 'using' for the connection, you should also add using to those 2 commands: using (OleDbCommand cmd8 = new ...Answered | 3 Replies | 1943 Views | Created by Jackson_1990 - Tuesday, December 17, 2013 7:48 AM | Last reply by Mike Danes - Tuesday, December 17, 2013 9:02 AM -
1 Votes
Where, Group By, Having, Order --- Usage sequence?
HI, Use in below Order: Example: Select Attitudename,Count(*) from ...Answered | 5 Replies | 20253 Views | Created by GurunGuns - Thursday, July 1, 2010 4:33 PM | Last reply by sud3eer - Friday, February 28, 2014 9:16 AM -
0 Votes
order by
DECLARE @col NVARCHAR(MAX) select @col = COALESCE(@col + ',','')+ QUOTENAME(Datename(month,date)) from form_Details WHERE Date between ...Answered | 4 Replies | 2459 Views | Created by amx_help - Wednesday, February 22, 2012 8:21 AM | Last reply by tkrasinger - Wednesday, February 22, 2012 8:40 AM -
1 Votes
OrderByDescending Within Group Not Working
Although the approach suggested by Syed works for me, I believe this is a bug within the SQL generator for EF.Answered | 4 Replies | 3710 Views | Created by NTDeveloper - Wednesday, May 12, 2010 8:23 PM | Last reply by NTDeveloper - Friday, May 28, 2010 2:30 AM -
0 Votes
How to prepare SyncNewReceivedAnchors for OLeDbCommand?
Wasn't able to do it with OledbCommand.Answered | 5 Replies | 13664 Views | Created by Ocherk - Monday, January 14, 2008 1:35 PM | Last reply by JorgeZimbo - Wednesday, November 4, 2009 3:53 PM -
0 Votes
Ordering Display Folders in Measure Group
I am not trying to move measure groups, I am trying to move the Display Folders within the measure groups.Answered | 3 Replies | 5110 Views | Created by Steve12354555555555 - Tuesday, May 18, 2010 3:11 PM | Last reply by Raymond-Lee - Thursday, May 20, 2010 4:11 AM -
0 Votes
How to Calculate Running Difference while ordering asc on date field
, ('2000', '3/10/2014',100,2000,375,125) , ('2000', '9/20/2014',200,2000,400,300) , ('2000', '4/27/2014',300,2000,675,1300) , ('3000', '3/17/2014',100,100,375,110) ...Answered | 1 Replies | 786 Views | Created by Milano85 - Friday, August 15, 2014 3:37 AM | Last reply by Jingyang Li - Friday, August 15, 2014 3:09 PM -
0 Votes
Counting Groups Within Groups
: Select PdNumber, Severity, count(severity) as AgencyByType from from tblCsCases where IssuedDate BETWEEN '20160101' AND '20161231' group by PdNumber, Severity Please ...Answered | 5 Replies | 592 Views | Created by Kurt Woodfin - Friday, January 27, 2017 5:19 PM | Last reply by Kurt Woodfin - Friday, January 27, 2017 7:00 PM - Items 1 to 20 of 858532 Next ›
No announcements
