Click here to Skip to main content
       

Database

 
GeneralRe: SQL 2008 Data Base Table Design suggestion PinmemberVishwaKL5-Dec-12 0:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion PinmemberSimon_Whale5-Dec-12 0:51 
AnswerRe: SQL 2008 Data Base Table Design suggestion PinmemberPIEBALDconsult5-Dec-12 4:56 
Question[HELP] how to using array in my case? (Query & PHP) [modified] Pinmemberjimmy.suharry4-Dec-12 21:14 
AnswerRe: [HELP] how to using array in my case? (Query & PHP) PinmemberMycroft Holmes4-Dec-12 21:38 
GeneralRe: [HELP] how to using array in my case? (Query & PHP) Pinmemberjimmy.suharry4-Dec-12 21:56 
QuestionSQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 4:09 
AnswerRe: SQL query Date Sort Problem Pinmemberihoecken3-Dec-12 5:42 
Did you try:
Select SNo, NoOfDays, [Month], [Year], [Days], [Holiday] From DaysMonth Where [Period]='November,2012' order by ToDate ASC
 
Perhaps the direct order of sorting with "ASC" could help.
 
AnirbanM 2 wrote:
Now, i'm using this query in web application using ASP.Net environment and C# language within a loop

Can't you let the SQL-Statement do the work of the loop? It would be more effective!
------------------------------
Author of Primary ROleplaying SysTem
 
How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.

GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:46 
AnswerRe: SQL query Date Sort Problem PinmemberEddy Vluggen3-Dec-12 6:20 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:48 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 0:00 
AnswerRe: SQL query Date Sort Problem Pinmemberdjj553-Dec-12 6:46 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 20:12 
AnswerRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 9:50 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 14:12 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 14:18 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 17:18 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 18:29 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:57 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:52 
AnswerRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 17:24 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 18:28 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 20:07 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 20:10 

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
Web01 | 2.8.141220.1 | Last Updated 21 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid