Hello
I am developing an application which pulls data from our P6 SQL database. In my application I want to display WBS and Task items hierarchically and beside each item display the start/finish dates.
In SQL I can write a Common Table Expression which will recursively loops through the WBS/Task data and calculates the start and finish dates for all of the WBS items but it is slow and I suspect unneccesary.
Assuming that the start and finish dates for each WBS item may be pre-calculated within the depths of the SQL data somewhere, how can I write a SELECT satatement to get WBS items included their related start/finish dates please?
Thank you.
Chris