SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Calculation on remaining months
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

huynhtl
Posting Yak Master

107 Posts

Posted - 04/21/2008 :  16:51:01  Show Profile  Reply with Quote
HI,
I want to know if there's an easier way to do a calculation on the remaining total of the months. For example: month 09 would be (total *3 ) because 9+3 = 12 and there are 12 months in a year.
month total
01 2217.3700
02 2187.6600
03 2243.6500
04 2216.1000
05 2374.4200
06 2296.2200
07 2266.6000
08 2164.2600
09 2085.2400

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 04/21/2008 :  17:25:55  Show Profile  Visit nr's Homepage  Reply with Quote
select month ,
total = case when month = (select max(month) from tbl) then (12 - month + 1) * total else total end
from tbl


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 04/21/2008 :  17:39:52  Show Profile  Reply with Quote
I have a question on why you have to add 1 to 12 -09? that would make it 09+4 instead of 09+3?
Can you clarify? 12-max(in this case is 09) (12-09+1) = 4?
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 04/21/2008 :  17:48:52  Show Profile  Visit nr's Homepage  Reply with Quote
You're right - but are you sure you don't want it to be *4 for month 9?
to represent months 9,10,11,12?

If not just omit the + 1 but you will have to decide what to do for a month 12 as that will be * 0.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 04/21/2008 :  17:54:19  Show Profile  Reply with Quote
Thanx.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000