Click here to Skip to main content
11,581,130 members (64,142 online)
   

Database

 
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 

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