Fill problem

Question

Hi,

 

I have a very complicate problem with SQL data files. Say that we have four data files:

 

F1=2000MB

F2=1000MB

F3=3000MB

F4=1500MB

 

I want to add 3000 MB on these files, and in the same time I want to make the files proportional one with each other:

 

F1 + 500=2500MB

F2 + 1500=2500MB

F4 + 1000=2500MB

 

At the end I’ll have:

 

F1=2500 MB

F2=2500 MB

F3=3000MB

F4=2500MB

 

 

I need and algorithm or a formula to calculate the values to add to each files F1, F2….Fn files having S1, S2….Sn sizes, for a T total value to add. Can anyone help me? Thank you in advance.

 

Answer 1

Please respond to this duplicate posting:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2331543&SiteID=1

 

This thread has been locked.

 

Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).