Click here to Skip to main content
12,452,721 members (54,899 online)
   

Database

 
AnswerRe: Using .Net and SMO on multiple SQL versions Pin
Eddy Vluggen12-Dec-12 3:10
memberEddy Vluggen12-Dec-12 3:10 
QuestionSelecting issue in SQl Server Pin
rakeshs31211-Dec-12 23:06
memberrakeshs31211-Dec-12 23:06 
AnswerRe: Selecting issue in SQl Server Pin
Eddy Vluggen12-Dec-12 3:07
memberEddy Vluggen12-Dec-12 3:07 
QuestionGenerating Code in Dept-001/Fin.Year Format Pin
Vinay Meka11-Dec-12 22:41
memberVinay Meka11-Dec-12 22:41 
QuestionRe: Generating Code in Dept-001/Fin.Year Format Pin
Eddy Vluggen12-Dec-12 3:06
memberEddy Vluggen12-Dec-12 3:06 
AnswerRe: Generating Code in Dept-001/Fin.Year Format Pin
Mycroft Holmes12-Dec-12 11:53
memberMycroft Holmes12-Dec-12 11:53 
QuestionHow to print an SSRS Report in PDF Format from my asp.net page Pin
Vinay Meka11-Dec-12 17:55
memberVinay Meka11-Dec-12 17:55 
AnswerRe: How to print an SSRS Report in PDF Format from my asp.net page - Crosspost Pin
Richard MacCutchan11-Dec-12 21:30
mvpRichard MacCutchan11-Dec-12 21:30 
Questionreading individual files in a database backup set Pin
Dan_K10-Dec-12 22:44
memberDan_K10-Dec-12 22:44 
AnswerRe: reading individual files in a database backup set Pin
djj5511-Dec-12 3:58
memberdjj5511-Dec-12 3:58 
QuestionJava Struts2 Framework Pin
Maheshwari Anand10-Dec-12 2:46
memberMaheshwari Anand10-Dec-12 2:46 
AnswerRe: Java Struts2 Framework Pin
Mycroft Holmes10-Dec-12 18:39
memberMycroft Holmes10-Dec-12 18:39 
AnswerRe: Java Struts2 Framework Pin
Richard MacCutchan10-Dec-12 21:39
mvpRichard MacCutchan10-Dec-12 21:39 
QuestionSQL Query To select result for monthly Pin
VishwaKL9-Dec-12 22:43
memberVishwaKL9-Dec-12 22:43 
Hi

I want to select result for yearly report, i want total number of request raised per month and how many request solved per month,

it should show '0' if the month not having request and solved request.

Like

Month Total Requests Solved Request
1 0 0
2 34 30
3 38 38
4 5 5
5 78 67
6 10 10
7 10 9
8 12 11
9 90 89
10 24 23
11 12 10
12 11 09


please help me
AnswerRe: SQL Query To select result for monthly Pin
Eddy Vluggen9-Dec-12 23:12
memberEddy Vluggen9-Dec-12 23:12 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:15
memberVishwaKL9-Dec-12 23:15 
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 
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 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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.160826.1 | Last Updated 27 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid