Click here to Skip to main content
Search within:



       

Database

 
Hint: For improved responsiveness ensure Javascript is enabled and choose 'Normal' from the Layout dropdown and hit 'Update'.
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page  Show 
FirstPrevNext
AnswerRe: SQL Query To select result for monthlymemberEddy Vluggen9 Dec '12 - 23:12 
GeneralRe: SQL Query To select result for monthlymemberVishwaKL9 Dec '12 - 23:15 
GeneralRe: SQL Query To select result for monthlymemberEddy Vluggen9 Dec '12 - 23:18 
GeneralRe: SQL Query To select result for monthlymemberVishwaKL9 Dec '12 - 23:20 
GeneralRe: SQL Query To select result for monthlymemberEddy Vluggen9 Dec '12 - 23:24 
GeneralRe: SQL Query To select result for monthlymemberVishwaKL9 Dec '12 - 23:27 
AnswerRe: SQL Query To select result for monthlymemberDavid Mujica10 Dec '12 - 3:16 
Since you did not post the structure of your table, I will have to give a very general asnwer.
 
Something like:
 
select month(ticket_created_date),count(ticket_created_date),count(ticket_closed_date)
from myTickets
group by month(ticket_created_date)
 
If this helps, Remeber to vote.
Thumbs Up | :thumbsup:
Sign In·View Thread·Permalink
GeneralRe: SQL Query To select result for monthlymemberVishwaKL10 Dec '12 - 14:48 
GeneralRe: SQL Query To select result for monthlymemberShameel10 Dec '12 - 21:34 
GeneralRe: SQL Query To select result for monthlymemberJ4amieC11 Dec '12 - 0:11 
GeneralRe: SQL Query To select result for monthlymemberVishwaKL11 Dec '12 - 14:54 
AnswerRe: SQL Query To select result for monthlymemberMS SQL DEVELOPER10 Dec '12 - 23:35 
QuestionHow to get the closing balance to be the opening balance of the following monthmembervusamozi9 Dec '12 - 19:23 
AnswerRe: How to get the closing balance to be the opening balance of the following monthmemberEddy Vluggen9 Dec '12 - 23:13 
AnswerRe: How to get the closing balance to be the opening balance of the following monthmember@AmitGajjar11 Dec '12 - 7:17 
QuestionSelect All Months and related datamemberVishwaKL6 Dec '12 - 22:21 
AnswerRe: Select All Months and related datamemberBlue_Boy7 Dec '12 - 1:18 
GeneralRe: Select All Months and related datamemberMycroft Holmes8 Dec '12 - 20:57 
GeneralRe: Select All Months and related datamemberVishwaKL9 Dec '12 - 19:06 
GeneralRe: Select All Months and related datamemberMycroft Holmes9 Dec '12 - 19:15 
GeneralRe: Select All Months and related datamemberVishwaKL9 Dec '12 - 19:19 
GeneralRe: Select All Months and related datamemberVishwaKL9 Dec '12 - 18:37 
GeneralRe: Select All Months and related datamemberDeepak Kr110 Dec '12 - 19:27 
GeneralRe: Select All Months and related datamemberVishwaKL10 Dec '12 - 19:31 
GeneralRe: Select All Months and related datamemberDeepak Kr110 Dec '12 - 21:02 
Last Visit: 31 Dec '99 - 18:00     Last Update: 23 May '13 - 4:41Refresh« Prev1...37383940414243444546 Next »

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


Advertise | Privacy | Mobile
Web03 | 2.6.130523.1 | Last Updated 23 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid