No announcements
Found 2526149 threads
-
0 Votesmake order for sql statement
In Visual FoxPro you can not use a function for the field in the ORDER BY.Answered | 3 Replies | 1883 Views | Created by Alaa Mukhtar - Monday, February 27, 2012 9:40 AM | Last reply by KoenP - Monday, February 27, 2012 10:55 PM
-
1 Votes
Using Order by in a Group by statement
because the month is out of order Month (No column name) Apr 52 Jul 12 Jun 67 May 24Answered | 5 Replies | 3536 Views | Created by SQL_1980 - Wednesday, August 5, 2009 11:52 AM | Last reply by sqlguruu - Wednesday, August 5, 2009 12:38 PM -
0 Votes
expert order by statement
Here is how it works.Answered | 11 Replies | 3183 Views | Created by philliptackett77 - Wednesday, July 13, 2011 11:54 PM | Last reply by Gert-Jan Strik - Thursday, July 14, 2011 9:52 PM -
0 Votes
A T-SQL statement that does not work.
It works now.Answered | 12 Replies | 777 Views | Created by MyCatAlex - Sunday, August 26, 2018 5:33 PM | Last reply by Erland Sommarskog - Monday, August 27, 2018 7:23 AM -
0 Votes
Sql statement not working very well.
The way to debug a statement that you are not getting expected rows is to dissect it.Answered | 6 Replies | 727 Views | Created by msimo1 - Saturday, March 26, 2016 11:40 PM | Last reply by Carl G. Sopchak - Tuesday, March 29, 2016 9:56 PM -
0 Votes
Using Order by in a SQL Create or Alter statement
Balaji, You can't specify an 'order by' in the table definition.Answered | 2 Replies | 3467 Views | Created by Balaji Palamadai - Friday, November 18, 2011 12:42 PM | Last reply by Sean Gallardy - Friday, November 18, 2011 2:51 PM -
0 Votes
Transact SQL statement not working
Hello, Just as JuneT post, you should check the supported statements in Windows Azure SQL Database first.If you want to export to a txt file, you can using BCP ...Answered | 4 Replies | 3459 Views | Created by Gad999 - Friday, September 13, 2013 12:49 AM | Last reply by Fanny Liu - Friday, September 20, 2013 7:44 AM -
0 Votes
SQL Statement not working
Third day of any SQL class?Answered | 8 Replies | 1328 Views | Created by EMKISER - Monday, November 19, 2012 10:00 PM | Last reply by EMKISER - Tuesday, November 20, 2012 4:21 PM -
0 Votes
Sql statement with Case not working
Parts of the system were 4-5 orders of magnitude faster.Answered | 11 Replies | 3929 Views | Created by dodgeballsouth - Wednesday, June 19, 2013 1:35 PM | Last reply by dodgeballsouth - Wednesday, June 19, 2013 8:39 PM -
0 Votes
sql server 2005 ascending sort order not working
Hello, Have you defined an explicit ORDER BY clause in your SELECT statement?Answered | 2 Replies | 6889 Views | Created by Kevinwnz - Wednesday, April 27, 2011 3:29 AM | Last reply by - Friday, May 6, 2011 4:12 AM -
1 Votes
sql statement works fine but doesn't work in SP
Hi Scott, Using set worked for me, though I really don't understand why it doesn't work with select, that too only in a big stored procedure.Answered | 7 Replies | 2202 Views | Created by Krishna Chaithanya - Thursday, January 31, 2013 6:00 PM | Last reply by scott_morris-ga - Friday, February 1, 2013 4:04 PM -
6 Votes
Order of Execution of SQL Queries
First of all, if you have a suite of statements, these statements are executed in order, and in SQL Server there is no optimisation between ...Answered | 8 Replies | 105078 Views | Created by ryguy72 - Saturday, August 25, 2012 3:09 PM | Last reply by Erland Sommarskog - Thursday, July 18, 2013 8:35 PM -
0 Votes
case statement in dynamic sql not working
As you have discovered, writing dynamic SQL is difficult.Answered | 3 Replies | 7164 Views | Created by MKG2011 - Saturday, February 25, 2012 8:22 PM | Last reply by Erland Sommarskog - Sunday, February 26, 2012 5:25 PM -
0 Votes
Order of rows in select statement
Latheesh is right. that there is no guarrantee for SQl server to return back the value in a particular order unless that you specifically use the Order By clause.Answered | 2 Replies | 2804 Views | Created by Previn Kumar - Tuesday, July 31, 2012 9:18 AM | Last reply by Steven Wang - Shangzhou - Tuesday, July 31, 2012 10:26 AM -
5 Votes
Does the order of the join statements matter?
Well the order makes no difference in the result.Answered | 9 Replies | 19597 Views | Created by battlFrog - Monday, March 26, 2012 5:44 PM | Last reply by Tom Cooper - Tuesday, November 19, 2013 3:13 AM -
2 Votes
ORDER BY not allowed on Azure SQL
To reiterate what dsmwb's link say, partition By Order by is supported on SQL Azure Database v12.Answered | 4 Replies | 1022 Views | Created by wakefun - Thursday, November 26, 2015 2:28 PM | Last reply by Casey Karst - Monday, November 30, 2015 6:08 PM -
0 Votes
How To Terminate SQL Statement
But in my scenaro the SQL Stmt should be terminated while we populate the Order table itself.Answered | 17 Replies | 5578 Views | Created by Anoop83 - Thursday, August 26, 2010 6:17 PM | Last reply by Anoop83 - Friday, August 27, 2010 2:04 PM -
0 Votes
why this SQL statement does not work?
1000 Also, if user_id is a key to the table you can just use: select user_Id from sec_User where user_Id > ...Answered | 2 Replies | 3918 Views | Created by qkc - Thursday, June 23, 2011 6:31 PM | Last reply by Kent Waldrop - Thursday, June 23, 2011 6:40 PM -
0 Votes
ORDER BY clause statement
Main use is to order the rows.Answered | 1 Replies | 886 Views | Created by shah3625 - Sunday, December 29, 2013 5:10 PM | Last reply by Russ Loski - Sunday, December 29, 2013 5:16 PM -
0 Votes
insert statement does not work
The goal is to have one statement with some parameters in the body of the proc and to use no more than ~50 lines at the maximum.Answered | 5 Replies | 2030 Views | Created by Dkuud - Wednesday, September 11, 2013 8:52 PM | Last reply by --CELKO-- - Wednesday, September 11, 2013 11:10 PM - Items 1 to 20 of 2526149 Next ›
No announcements
