Click here to Skip to main content
12,511,553 members (51,816 online)
   

Database

 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
PIEBALDconsult5-Dec-12 3:56
memberPIEBALDconsult5-Dec-12 3:56 
Question[HELP] how to using array in my case? (Query & PHP) Pin
jimmy.suharry4-Dec-12 20:14
memberjimmy.suharry4-Dec-12 20:14 
AnswerRe: [HELP] how to using array in my case? (Query & PHP) Pin
Mycroft Holmes4-Dec-12 20:38
memberMycroft Holmes4-Dec-12 20:38 
GeneralRe: [HELP] how to using array in my case? (Query & PHP) Pin
jimmy.suharry4-Dec-12 20:56
memberjimmy.suharry4-Dec-12 20:56 
QuestionSQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 3:09
memberAnirbanM 23-Dec-12 3:09 
AnswerRe: SQL query Date Sort Problem Pin
ihoecken3-Dec-12 4:42
memberihoecken3-Dec-12 4:42 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:46
memberAnirbanM 23-Dec-12 18:46 
AnswerRe: SQL query Date Sort Problem Pin
Eddy Vluggen3-Dec-12 5:20
memberEddy 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 Pin
AnirbanM 23-Dec-12 18:48
memberAnirbanM 23-Dec-12 18:48 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen3-Dec-12 23:00
memberEddy Vluggen3-Dec-12 23:00 
AnswerRe: SQL query Date Sort Problem Pin
djj553-Dec-12 5:46
memberdjj553-Dec-12 5:46 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:12
memberAnirbanM 23-Dec-12 19:12 
AnswerRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 8:50
memberPIEBALDconsult3-Dec-12 8:50 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 13:12
memberMycroft Holmes3-Dec-12 13:12 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 13:18
memberPIEBALDconsult3-Dec-12 13:18 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 16:18
memberMycroft Holmes3-Dec-12 16:18 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 17:29
memberPIEBALDconsult3-Dec-12 17:29 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:57
memberAnirbanM 23-Dec-12 18:57 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 18:52
memberAnirbanM 23-Dec-12 18:52 
AnswerRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 16:24
memberMycroft Holmes3-Dec-12 16:24 
GeneralRe: SQL query Date Sort Problem Pin
PIEBALDconsult3-Dec-12 17:28
memberPIEBALDconsult3-Dec-12 17:28 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:07
memberAnirbanM 23-Dec-12 19:07 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 23-Dec-12 19:10
memberAnirbanM 23-Dec-12 19:10 
GeneralRe: SQL query Date Sort Problem Pin
Mycroft Holmes3-Dec-12 19:48
memberMycroft Holmes3-Dec-12 19:48 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 2:12
memberAnirbanM 24-Dec-12 2:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web01 | 2.8.160929.1 | Last Updated 29 Sep 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid