Home Forums SQL Server 2008 SQL Server 2008 - General Position count excluding Vacant positions in hierarchical data RE: Position count excluding Vacant positions in hierarchical data
vrushali.sawant
SSC Rookie
Points: 32
More actions
August 21, 2012 at 5:12 am
#1528050
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 you so much once again 🙂