InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 19:19:31 GMT20http://www.sqlservercentral.com/Forums/Topic1403352-1292-1.aspxThanks 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.5Mon, 07 Jan 2013 01:42:00 GMTkarna5999http://www.sqlservercentral.com/Forums/Topic1403352-1292-1.aspx[quote][b]karna5999 (1/6/2013)[/b][hr]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[/quote]ok..bit confused to the reason behind your questioneg....100/2....does this output 50 rows all as "2" ?What are you trying to achieve?Sun, 06 Jan 2013 14:11:12 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1403352-1292-1.aspxHow do I evenly divide $10752.00 into 7 In SSIS ?(even division of a decimal) For example:$102.10 / 2Result:- 51.05 51.05Sun, 06 Jan 2013 14:02:44 GMTkarna5999