Viewing 5 posts - 1 through 5 (of 5 total)
ChrisM@Work (11/27/2014)
If you can provide some readily-consumable sample data, someone will be more likely to put together a query for you.
Hi Chris, scenario is made available by now....thank you
November 27, 2014 at 5:13 am
This is the query... Can we achieve the same via some other method?
SELECT OS.NAME, OS.ITEMID, OS.PARENTID, OS2.NAME AS PARENTNAME, OS.HIERID, OS3.NAME AS HIERNAME,OS.HIERLEVEL,H.LEVELNAME
FROM OPERATIONALSTRUCTURE OS, OPERATIONALSTRUCTURE OS2, OPERATIONALSTRUCTURE OS3,HIERLEVELS H
WHERE...
August 8, 2012 at 4:48 am
Viewing 5 posts - 1 through 5 (of 5 total)