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.
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 total01 2217.370002 2187.660003 2243.650004 2216.100005 2374.420006 2296.220007 2266.600008 2164.260009 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 endfrom 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. |
|
|
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? |
|
|
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. |
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2008-04-21 : 17:54:19
|
Thanx. |
|
|
|
|
|