Click here to Skip to main content
       

Database

 
AnswerRe: SQL Query - append results PinmemberChris Meech5-Dec-12 6:55 
GeneralRe: SQL Query - append results PinmemberAndreFratelli5-Dec-12 7:08 
QuestionSQL 2008 Data Base Table Design suggestion PinmemberVishwaKL4-Dec-12 23:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion PinmemberSimon_Whale4-Dec-12 23:43 
GeneralRe: SQL 2008 Data Base Table Design suggestion PinmemberVishwaKL4-Dec-12 23:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion PinmemberSimon_Whale4-Dec-12 23:51 
AnswerRe: SQL 2008 Data Base Table Design suggestion PinmemberPIEBALDconsult5-Dec-12 3:56 
Question[HELP] how to using array in my case? (Query & PHP) [modified] Pinmemberjimmy.suharry4-Dec-12 20:14 
AnswerRe: [HELP] how to using array in my case? (Query & PHP) PinmemberMycroft Holmes4-Dec-12 20:38 
GeneralRe: [HELP] how to using array in my case? (Query & PHP) Pinmemberjimmy.suharry4-Dec-12 20:56 
QuestionSQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 3:09 
AnswerRe: SQL query Date Sort Problem Pinmemberihoecken3-Dec-12 4:42 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 18:46 
AnswerRe: SQL query Date Sort Problem PinmemberEddy Vluggen3-Dec-12 5:20 
AnirbanM 2 wrote:
Out of 100 times running this query, 97-98 times, it's producing correct result, however, 1-2 times, sort is not working, so instead of 1st to 31st, output coming like 10th to 31st then 1st to 10th.

From that, I'd say you have different collations (or regional settings on the client). But AFAIK, that would only apply to string-types, like VARCHAR and NTEXT.
 
Try converting the datetime to a fixed-format string, and sort on that.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 18:48 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen3-Dec-12 23:00 
AnswerRe: SQL query Date Sort Problem Pinmemberdjj553-Dec-12 5:46 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:12 
AnswerRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 8:50 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 13:12 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 13:18 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 16:18 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 17:29 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 18:57 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 18:52 
AnswerRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 16:24 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 17:28 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:07 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:10 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 19:48 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 24-Dec-12 2:12 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 24-Dec-12 2:30 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 3:12 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 24-Dec-12 3:27 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 4:44 
AnswerRe: SQL query Date Sort Problem PinmemberMichael Potter4-Dec-12 8:11 
AnswerRe: SQL query Date Sort Problem Pinmemberjschell4-Dec-12 8:23 
Questionoltp vs olap Pinmembera.fatemeh2-Dec-12 10:51 
AnswerRe: oltp vs olap PinmemberMycroft Holmes2-Dec-12 11:49 
GeneralRe: oltp vs olap Pinmembera.fatemeh2-Dec-12 11:57 
GeneralRe: oltp vs olap PinmemberMycroft Holmes2-Dec-12 13:28 
GeneralRe: oltp vs olap Pinmembera.fatemeh2-Dec-12 13:41 
GeneralSQL instance name when using network group PinmemberAamir Saleem2-Dec-12 10:32 
GeneralRe: SQL instance name when using network group PinmemberMycroft Holmes2-Dec-12 11:43 
QuestionACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 4:15 
AnswerRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 5:07 
GeneralRe: ACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 6:43 
GeneralRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 6:50 
QuestionSQL Query Pinmemberberba29-Nov-12 2:22 
AnswerRe: SQL Query PinmemberRichard Deeming29-Nov-12 2:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 25 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid