Yes, i am basically confused on the mathematical logic needed to be applied... I am not looking for percentage of the charges for a total value

I understand, i am unable to come up with a logic and can't tell you what the exact answer would be.. i am expecting the percentages to be around or...

I am not sure what the formula would be to calculate the percentage and that's the reason i am posting it here for your help

Thanks for the reply guys..

but i am not sure if that's the answer i am looking for.. so, i am trying to re phrase my original question and it might...

Thanks a Lot ,Bt

I used the same approach that you have suggested but in a little different fashion according to my Requirement.. I was working on other issues so could...

any suggestions/help please

I tried to take the same approach using the basic SQL not cursor though, but i am unable to go any further with the code.. Can you help me out...

I will definitly try it out. thanks

sturner,

how do i limit them. can you please provide me an example.

Thanks

thanks for the suggestion..but no luck..

Thanks a ton, that works great.. i have changed it accordingly.. Now the only thing i am worried about is Performance because this query is just a part of the...

Thanks a lot stefan, You are a life saver.. it almost worked until i executed it against the below example.. Since none of the two Values above and below are...

Posting your problem in multiple threads doesn't only waste resources, it also slows down the time until you get an answer that will actually solve your issue (especially if it...

The complete business requirement is described in this post

http://www.sqlservercentral.com/Forums/Topic940069-391-1.aspx?Update=1

I was able to finish most part of it, except that i am unable to apply this rule.. Records should be...

I have seen the article before posting, but i am unable to utilize it to solve the issue, though it is related to my post.. Can you guide me. Thanks