there is no defined set of formulas used here , it may vary for every row. So writing formulas into a case would ask of hardcoding , aim is to...

Thanks for the reply Mark/Eugene , this works fine for this combination of Primary key contraints i.e

1 a x 01-jan

1 a x 02-Jan

but it fails when i...

I have a lot of data in my Table , Dont you think it would look clumsy if we insert all the data to @T

as done in

DECLARE @t TABLE(L1...