Click here to Skip to main content
11,644,286 members (66,125 online)
   

Database

 
GeneralRe: SQL Query To select result for monthly Pin
Eddy Vluggen9-Dec-12 23:18
memberEddy Vluggen9-Dec-12 23:18 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:20
memberVishwaKL9-Dec-12 23:20 
GeneralRe: SQL Query To select result for monthly Pin
Eddy Vluggen9-Dec-12 23:24
memberEddy Vluggen9-Dec-12 23:24 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:27
memberVishwaKL9-Dec-12 23:27 
AnswerRe: SQL Query To select result for monthly Pin
David Mujica10-Dec-12 3:16
memberDavid Mujica10-Dec-12 3:16 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL10-Dec-12 14:48
memberVishwaKL10-Dec-12 14:48 
GeneralRe: SQL Query To select result for monthly Pin
Shameel10-Dec-12 21:34
memberShameel10-Dec-12 21:34 
GeneralRe: SQL Query To select result for monthly Pin
J4amieC11-Dec-12 0:11
memberJ4amieC11-Dec-12 0:11 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL11-Dec-12 14:54
memberVishwaKL11-Dec-12 14:54 
AnswerRe: SQL Query To select result for monthly Pin
MS SQL DEVELOPER10-Dec-12 23:35
memberMS SQL DEVELOPER10-Dec-12 23:35 
QuestionHow to get the closing balance to be the opening balance of the following month Pin
vusamozi9-Dec-12 19:23
membervusamozi9-Dec-12 19:23 
AnswerRe: How to get the closing balance to be the opening balance of the following month Pin
Eddy Vluggen9-Dec-12 23:13
memberEddy Vluggen9-Dec-12 23:13 
AnswerRe: How to get the closing balance to be the opening balance of the following month Pin
@AmitGajjar11-Dec-12 7:17
member@AmitGajjar11-Dec-12 7:17 
QuestionSelect All Months and related data Pin
VishwaKL6-Dec-12 22:21
memberVishwaKL6-Dec-12 22:21 
Hi guys

I have a problem to select query.

For yearly report i am getting by my query
SELECT  YEAR(RequestedDate) as Years, Month(RequestedDate) as MonthInNumbers,Count(Month(RequestedDate)) as MonthCount
 
FROM MYTABLE
 
GROUP BY YEAR(RequestedDate),Month(RequestedDate)

Year Month Total
2012 2 13
2012 3 61
2012 4 46
2012 5 48
2012 6 63
2012 10 54
2012 12 11


for this i want
Year Month Total
2012 1 0
2012 2 13
2012 3 61
2012 4 46
2012 5 48
2012 6 63
2012 7 0
2012 8 0
2012 9 0
2012 10 54
2012 11 0
2012 12 11


any help
AnswerRe: Select All Months and related data Pin
Blue_Boy7-Dec-12 1:18
memberBlue_Boy7-Dec-12 1:18 
GeneralRe: Select All Months and related data Pin
Mycroft Holmes8-Dec-12 20:57
memberMycroft Holmes8-Dec-12 20:57 
GeneralRe: Select All Months and related data Pin
VishwaKL9-Dec-12 19:06
memberVishwaKL9-Dec-12 19:06 
GeneralRe: Select All Months and related data Pin
Mycroft Holmes9-Dec-12 19:15
memberMycroft Holmes9-Dec-12 19:15 
GeneralRe: Select All Months and related data Pin
VishwaKL9-Dec-12 19:19
memberVishwaKL9-Dec-12 19:19 
GeneralRe: Select All Months and related data Pin
VishwaKL9-Dec-12 18:37
memberVishwaKL9-Dec-12 18:37 
GeneralRe: Select All Months and related data Pin
Deepak Kr110-Dec-12 19:27
memberDeepak Kr110-Dec-12 19:27 
GeneralRe: Select All Months and related data Pin
VishwaKL10-Dec-12 19:31
memberVishwaKL10-Dec-12 19:31 
GeneralRe: Select All Months and related data Pin
Deepak Kr110-Dec-12 21:02
memberDeepak Kr110-Dec-12 21:02 
GeneralRe: Select All Months and related data Pin
VishwaKL10-Dec-12 21:46
memberVishwaKL10-Dec-12 21:46 
GeneralRe: Select All Months and related data Pin
Deepak Kr110-Dec-12 22:25
memberDeepak Kr110-Dec-12 22:25 
QuestionSSRS 2005 Pin
berba6-Dec-12 6:32
memberberba6-Dec-12 6:32 
AnswerRe: SSRS 2005 Pin
David Mujica6-Dec-12 7:59
memberDavid Mujica6-Dec-12 7:59 
AnswerRe: SSRS 2005 Pin
djj556-Dec-12 9:30
memberdjj556-Dec-12 9:30 
AnswerRe: SSRS 2005 Pin
Mycroft Holmes6-Dec-12 16:57
memberMycroft Holmes6-Dec-12 16:57 
GeneralRe: SSRS 2005 Pin
berba6-Dec-12 18:06
memberberba6-Dec-12 18:06 
GeneralRe: SSRS 2005 Pin
Mycroft Holmes6-Dec-12 21:43
memberMycroft Holmes6-Dec-12 21:43 
QuestionSQL Group By Question Pin
loyal ginger6-Dec-12 5:27
memberloyal ginger6-Dec-12 5:27 
AnswerRe: SQL Group By Question Pin
Blue_Boy6-Dec-12 10:11
memberBlue_Boy6-Dec-12 10:11 
GeneralRe: SQL Group By Question Pin
loyal ginger31-Dec-12 5:48
memberloyal ginger31-Dec-12 5:48 
QuestionIssues installing ODP.NETx64 Pin
cpp_prgmer6-Dec-12 4:18
membercpp_prgmer6-Dec-12 4:18 
AnswerRe: Issues installing ODP.NETx64 Pin
Eddy Vluggen6-Dec-12 14:37
memberEddy Vluggen6-Dec-12 14:37 
GeneralRe: Issues installing ODP.NETx64 Pin
Peter_in_27806-Dec-12 15:12
memberPeter_in_27806-Dec-12 15:12 
GeneralRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 16:52
memberMycroft Holmes6-Dec-12 16:52 
AnswerRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 16:53
memberMycroft Holmes6-Dec-12 16:53 
QuestionSQL Query - append results Pin
AndreFratelli5-Dec-12 6:43
memberAndreFratelli5-Dec-12 6:43 
AnswerRe: SQL Query - append results Pin
Chris Meech5-Dec-12 6:55
memberChris Meech5-Dec-12 6:55 
GeneralRe: SQL Query - append results Pin
AndreFratelli5-Dec-12 7:08
memberAndreFratelli5-Dec-12 7:08 
QuestionSQL 2008 Data Base Table Design suggestion Pin
VishwaKL4-Dec-12 23:36
memberVishwaKL4-Dec-12 23:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale4-Dec-12 23:43
memberSimon_Whale4-Dec-12 23:43 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
VishwaKL4-Dec-12 23:47
memberVishwaKL4-Dec-12 23:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale4-Dec-12 23:51
memberSimon_Whale4-Dec-12 23:51 
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 

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
Web02 | 2.8.150731.1 | Last Updated 31 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid