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 |
|
vijayshankar2003
Starting Member
4 Posts |
 Posted - 2012-09-16 : 14:54:46
|
| Hello guys... My scenario is, i have calculated days on the basis of difference of 2 input dates. Now i have to calculate a amount based on the days i calculated...for example, if the days calculated is 20... then the amount should get calculated with respect to slab defined for it....0 -5 ->105-15 ->2015-30 ->30now in 20 days, for first 5 days it should have (5x10=50)and from 6 to 15 (20x10) and from 16-20 ( 30x5) hope am clear in wat am asking???Vijay Shankar |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-16 : 15:22:10
|
| how are slabs stored? is it single field containing range ifo (ie as 0-5,6-15 etc) or do you've two fields start and end range?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Calculating values based on slabs