Thank you ChrisM It's close. Record PK=6 should not be updated because size increased by 4 char instead of 2. I will see if I can correct this

Thank you guys for your help. I missed one important condition. Value in CustArea column for SS record can be different. It can increase by 2 char at the time....

It will work.

Thank you

I agree with your assessment but data coming from different vendors and my task to reconcile it. I can’t change table structure

thank you. This will work

Thank you, exactly what I need

It's perfect. Thank you for your help

Amount PK1 is reduced based on percentage of all recs where Value and date is the same.300 + 200 + 100 = 100%. 300 represents is 50 % of 10...

Solved

I have sql 2008, LAG wouldn't work

I have SQL 2008, LAG wouldn't work

Thank you SSCEnt and SSCChamp. Both solutions will work.

cost for product and terminal based on the date requested by user. If user requested date 12/01/2014 I want to see max date that is equal or less then 12/01/2014