## SSIS Division

 Author Message SSC-Learner SSC Journeyman Group: General Forum Members Points: 84 Visits: 219 How do I evenly divide \$10752.00 into 7 In SSIS ?(even division of a decimal) For example:\$102.10 / 2Result:- 51.05 51.05 NOBODY REMAINS VIRGIN LIFE FU**S EVERY ONE.. J Livingston SQL One Orange Chip Group: General Forum Members Points: 27440 Visits: 41403 karna5999 (1/6/2013)How do I evenly divide \$10752.00 into 7 In SSIS ?(even division of a decimal) For example:\$102.10 / 2Result:- 51.05 51.05ok..bit confused to the reason behind your questioneg....100/2....does this output 50 rows all as "2" ?What are you trying to achieve? ________________________________________________________________you can lead a user to data....but you cannot make them think and remember....every day is a school day SSC-Learner SSC Journeyman Group: General Forum Members Points: 84 Visits: 219 Thanks for your replay i need to divide \$10752.00 for 7 rows Ex:-There is 2 different source tables:-Table#1custno Guid policytype amount 1 123 901 \$10002 123 901 \$2310 3 345 902 \$91234 345 902 \$2341 etc..Table#2Guid policytype Bonus 123 901 \$1211345 902 \$1217 etc...need to divide table#2 bonus \$1211 for all 901 policy type holders in table#1 Result should be like this:custno Guid policytype amount 1 123 901 \$1605.52 123 901 \$2915.5 3 345 902 \$9731.54 345 902 \$2949.5 NOBODY REMAINS VIRGIN LIFE FU**S EVERY ONE..