Click here to Skip to main content
       

Database

 
AnswerRe: How to print an SSRS Report in PDF Format from my asp.net page - Crosspost PinmvpRichard MacCutchan11-Dec-12 22:30 
Questionreading individual files in a database backup set PinmemberDan_K10-Dec-12 23:44 
AnswerRe: reading individual files in a database backup set Pinmemberdjj5511-Dec-12 4:58 
QuestionJava Struts2 Framework PinmemberMaheshwari Anand10-Dec-12 3:46 
AnswerRe: Java Struts2 Framework PinmemberMycroft Holmes10-Dec-12 19:39 
AnswerRe: Java Struts2 Framework PinmvpRichard MacCutchan10-Dec-12 22:39 
QuestionSQL Query To select result for monthly PinmemberVishwaKL9-Dec-12 23:43 
AnswerRe: SQL Query To select result for monthly PinmemberEddy Vluggen10-Dec-12 0:12 
GeneralRe: SQL Query To select result for monthly PinmemberVishwaKL10-Dec-12 0:15 
GeneralRe: SQL Query To select result for monthly PinmemberEddy Vluggen10-Dec-12 0:18 
GeneralRe: SQL Query To select result for monthly PinmemberVishwaKL10-Dec-12 0:20 
GeneralRe: SQL Query To select result for monthly PinmemberEddy Vluggen10-Dec-12 0:24 
GeneralRe: SQL Query To select result for monthly PinmemberVishwaKL10-Dec-12 0:27 
AnswerRe: SQL Query To select result for monthly PinmemberDavid Mujica10-Dec-12 4: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:
GeneralRe: SQL Query To select result for monthly PinmemberVishwaKL10-Dec-12 15:48 
GeneralRe: SQL Query To select result for monthly PinmemberShameel10-Dec-12 22:34 
GeneralRe: SQL Query To select result for monthly PinmemberJ4amieC11-Dec-12 1:11 
GeneralRe: SQL Query To select result for monthly PinmemberVishwaKL11-Dec-12 15:54 
AnswerRe: SQL Query To select result for monthly PinmemberMS SQL DEVELOPER11-Dec-12 0:35 
QuestionHow to get the closing balance to be the opening balance of the following month Pinmembervusamozi9-Dec-12 20:23 
AnswerRe: How to get the closing balance to be the opening balance of the following month PinmemberEddy Vluggen10-Dec-12 0:13 
AnswerRe: How to get the closing balance to be the opening balance of the following month Pinmember@AmitGajjar11-Dec-12 8:17 
QuestionSelect All Months and related data PinmemberVishwaKL6-Dec-12 23:21 
AnswerRe: Select All Months and related data PinmemberBlue_Boy7-Dec-12 2:18 
GeneralRe: Select All Months and related data PinmemberMycroft Holmes8-Dec-12 21:57 
GeneralRe: Select All Months and related data PinmemberVishwaKL9-Dec-12 20:06 
GeneralRe: Select All Months and related data PinmemberMycroft Holmes9-Dec-12 20:15 
GeneralRe: Select All Months and related data PinmemberVishwaKL9-Dec-12 20:19 
GeneralRe: Select All Months and related data PinmemberVishwaKL9-Dec-12 19:37 
GeneralRe: Select All Months and related data PinmemberDeepak Kr110-Dec-12 20:27 
GeneralRe: Select All Months and related data PinmemberVishwaKL10-Dec-12 20:31 
GeneralRe: Select All Months and related data PinmemberDeepak Kr110-Dec-12 22:02 
GeneralRe: Select All Months and related data PinmemberVishwaKL10-Dec-12 22:46 
GeneralRe: Select All Months and related data PinmemberDeepak Kr110-Dec-12 23:25 
QuestionSSRS 2005 Pinmemberberba6-Dec-12 7:32 
AnswerRe: SSRS 2005 PinmemberDavid Mujica6-Dec-12 8:59 
AnswerRe: SSRS 2005 Pinmemberdjj556-Dec-12 10:30 
AnswerRe: SSRS 2005 PinmemberMycroft Holmes6-Dec-12 17:57 
GeneralRe: SSRS 2005 Pinmemberberba6-Dec-12 19:06 
GeneralRe: SSRS 2005 PinmemberMycroft Holmes6-Dec-12 22:43 
QuestionSQL Group By Question [modified] Pinmemberloyal ginger6-Dec-12 6:27 
AnswerRe: SQL Group By Question PinmemberBlue_Boy6-Dec-12 11:11 
GeneralRe: SQL Group By Question Pinmemberloyal ginger31-Dec-12 6:48 
QuestionIssues installing ODP.NETx64 Pinmembercpp_prgmer6-Dec-12 5:18 
AnswerRe: Issues installing ODP.NETx64 PinmemberEddy Vluggen6-Dec-12 15:37 
GeneralRe: Issues installing ODP.NETx64 PinmemberPeter_in_27806-Dec-12 16:12 
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 

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
Web03 | 2.8.1411023.1 | Last Updated 27 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid