need help in adding the values of 2 sql quries

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

C#

ASP.NET

, +

Hi all

i m want to add the below query result and have to show in grid after year change

please tell me how to do

SQL

SELECT 15- sum(EL) as el, 1 - sum(CL) as cl, 14 - sum(ML) as ml FROM attendance

//current value of this query

SQL

SELECT 15- sum(EL) as el, 1 - sum(CL) as cl, 14 - sum(ML) as ml FROM attendance

//new values of this query

Posted 28-Oct-12 20:45pm

Code-Hunt

Updated 30-Oct-12 18:50pm

AshishChaudha

v3

Add a Solution

Comments

Sushil Mate 29-Oct-12 3:00am

What exactly you wanted to achieve here.? please explain in detail.

[no name] 29-Oct-12 3:04am

What i want is when the year ends the remaining leave values should add up with the fresh leave values..
e.g suppose if at 31st dec leave for a particular person remain
EL-10
CL-1
ML-5
then at 1st jan 2013 it should add up with new values and save in table as total(suppose all leaves are #10)
EL-20
CL-11
ML-15

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2012-10-28T21:10:00

Solution 1

GROUP BY[^] clause might be what you are looking for.

Posted 28-Oct-12 21:10pm

Abhinav S

Comments

[no name] 29-Oct-12 3:37am

let me tell u the problem again..
What i want is when the year ends the remaining leave values should add up with the fresh leave values..
e.g suppose if at 31st dec leave for a particular person remain
EL-10
CL-1
ML-5
then at 1st jan 2013 it should add up with new values and save in table as total(suppose all leaves are #10)
EL-20
CL-11
ML-15

damodara naidu betha 30-Oct-12 3:30am

hi.. what is the table structure? and explain EL,CL,ML.

[no name] 30-Oct-12 3:35am

EL,CL, ML are the types of leave for each emp.

ahmad zrein · Answer 2 · 2012-10-30T16:01:00

Solution 2

use substr
int lnlenght=varaible.lenght
nvaraible=convert.todecimal(variable.Substring(3, length);
nvariable = nvaraible +10

newvariable = variable.Substring(0, 3)+nvaraible

Posted 30-Oct-12 16:01pm

ahmad zrein

Comments

[no name] 31-Oct-12 1:31am

I didn't get ur code..can u please explain..

ahmad zrein 31-Oct-12 9:38am

the query defined do not work.

1. when we use sum or mathematical variable ist sould be done alone, because we must use group by.

SELECT sum(EL) as el, sum(CL) as cl, sum(ML) as ml FROM attendance group by date or id ....

2. What i mean divide the work into two part
part 1 do the sum query
part 2 do subtraction 15, 1, 14 ...
as you want

hope this what i understood