• So just to reiterate, you have a system but you can't share the design. You need to build a hierarchy but you can't share or create any sample data. Even if you could share, the system is entirely too complicated to put together enough details to come up with some sample data.

    However, you need to get data out of this system and you can't do it without some help because the system is so complicated you don't know how to go about it.

    Sounds to me there is about one choice left, hire a consultant have them sign a nondisclosure agreement.

    I don't mean to sound rude but honestly there is nothing we can do here.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/