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 06, 2013 2:02 PM
 Forum Newbie Group: General Forum Members Last Login: Wednesday, December 04, 2013 12:55 AM Points: 6, Visits: 149
 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 06, 2013 2:11 PM
 SSCommitted Group: General Forum Members Last Login: Today @ 12:36 PM Points: 1,557, Visits: 15,928
 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 !__________________________________________________________________
Post #1403353
 Posted Monday, January 07, 2013 1:42 AM
 Forum Newbie Group: General Forum Members Last Login: Wednesday, December 04, 2013 12:55 AM Points: 6, Visits: 149
 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