Hi Chris.

Thank You....

Yes it good to use table variables..... happy that im thinking in the right way

Hi,

Had done the same way but did not use "partition by" so was not able to get the exact output

Thanks for the reply... It helped me and solved it 🙂

Hi,

Tried using both the queries

It helped....me 🙂

Thanks a lot.