Click here to Skip to main content
   

Database

 
GeneralRe: Issues installing ODP.NETx64 PinmemberMycroft Holmes6-Dec-12 17:52 
AnswerRe: Issues installing ODP.NETx64 PinmemberMycroft Holmes6-Dec-12 17:53 
QuestionSQL Query - append results PinmemberAndreFratelli5-Dec-12 7:43 
AnswerRe: SQL Query - append results PinmemberChris Meech5-Dec-12 7:55 
GeneralRe: SQL Query - append results PinmemberAndreFratelli5-Dec-12 8:08 
QuestionSQL 2008 Data Base Table Design suggestion PinmemberVishwaKL5-Dec-12 0:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion PinmemberSimon_Whale5-Dec-12 0:43 
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 
I have a simple SQL table as follows:
CREATE TABLE [dbo].[DaysMonth](
    [SNo] [int] NOT NULL,
    [Month] [varchar](20) NOT NULL,
    [Year] [varchar](4) NOT NULL,
    [NoOfDays] [int] NOT NULL,
    [Days] [nchar](10) NULL,
    [Holiday] [nchar](1) NULL,
    [ToDate] [date] NULL,
    [Period] [nchar](30) NULL,
Following is the query:
Select SNo, NoOfDays, [Month], [Year], [Days], [Holiday] From DaysMonth Where [Period]='November,2012' order by ToDate
Now, i'm using this query in web application using ASP.Net environment and C# language within a loop. using SQL Server 2008. basic purpose here is to get all days within a period, say January,2012 in a sorted manner.
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. Getting puzzled, as it's a huge application running on multi-user environment, getting very difficult to take care of error which is absolutely unpredictable and illogical. Please suggest where is the problem, thanks to all in advance.
AnswerRe: SQL query Date Sort Problem Pinmemberihoecken3-Dec-12 5:42 
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 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 20:48 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 24-Dec-12 3:12 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 24-Dec-12 3:30 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 4:12 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 24-Dec-12 4:27 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 5:44 
AnswerRe: SQL query Date Sort Problem PinmemberMichael Potter4-Dec-12 9:11 
AnswerRe: SQL query Date Sort Problem Pinmemberjschell4-Dec-12 9:23 
Questionoltp vs olap Pinmembera.fatemeh2-Dec-12 11:51 
AnswerRe: oltp vs olap PinmemberMycroft Holmes2-Dec-12 12:49 
GeneralRe: oltp vs olap Pinmembera.fatemeh2-Dec-12 12:57 
GeneralRe: oltp vs olap PinmemberMycroft Holmes2-Dec-12 14:28 
GeneralRe: oltp vs olap Pinmembera.fatemeh2-Dec-12 14:41 
GeneralSQL instance name when using network group PinmemberAamir Saleem2-Dec-12 11:32 
GeneralRe: SQL instance name when using network group PinmemberMycroft Holmes2-Dec-12 12:43 
QuestionACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 5:15 
AnswerRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 6:07 
GeneralRe: ACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 7:43 

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.150301.1 | Last Updated 1 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid