Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 SSIS Division Rate Topic Display Mode Topic Options
Author
 Message
 Posted Sunday, January 6, 2013 2:02 PM
 Forum Newbie Group: General Forum Members Last Login: Monday, October 26, 2015 10:23 AM Points: 6, 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..
Post #1403352
 Posted Sunday, January 6, 2013 2:11 PM
 Hall of Fame Group: General Forum Members Last Login: 2 days ago @ 10:45 PM Points: 3,314, Visits: 32,575
 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
Post #1403353
 Posted Monday, January 7, 2013 1:42 AM
 Forum Newbie Group: General Forum Members Last Login: Monday, October 26, 2015 10:23 AM Points: 6, 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..
Post #1403470

 Permissions