Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Calculation on remaining months

Author  Topic 

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-04-21 : 16:51:01
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

12543 Posts

Posted - 2008-04-21 : 17:25:55
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 - 2008-04-21 : 17:39:52
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

12543 Posts

Posted - 2008-04-21 : 17:48:52
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 - 2008-04-21 : 17:54:19
Thanx.
Go to Top of Page
   

- Advertisement -