OK so following on from the last installment I realised that whilst my quick and dirty solution would give me all the children (WBS) parts of a parent project they were still not related. So if you need for instance a report that includes financials for WBS but you only want to report at parent level then those relationships between a parent and all children need to be defined.

What did I do? I took the earlier query I had written (which was now a stored a procedure) and wrapped another stored procedure around it so that I can now get all the children and top level parents for reporting. How did I do it? Simply contact me and I’ll happily share the code! It doesn’t build the hierarchy on the fly as it takes too long to do this and do the financial sums so it runs as a job and stores the hierarchy in separate tables.