• Hi H4K,

    The Levels function to which you refer is zero based, meaning that LEVELS(1) is the second level in the hierarchy. Can you try adding another level to the hierarchy below full date?

    SQL SERVER Central Forum Etiquette[/url]