Thanks a Lot,

This absolutely working fine for me. :)))

I was actually checking that Employee ID not null condition in CTE which was not calculating vacant positions and positions below vacant.

Thank...