Direct Reports
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Direct Reports
| Line 1: | Line 1: | ||
| - | [[Microsoft SQL Server]] to find Direct and Indirect Reports of a manager in [[PeopleSoft HRMS]] (that determines the management hierarchy by Position Management): | + | [[Microsoft SQL Server]] SQL query to find Direct and Indirect Reports of a manager in [[PeopleSoft HRMS]] (that determines the management hierarchy by Position Management): |
<pre> | <pre> | ||
WITH POSITION_TREE AS ( | WITH POSITION_TREE AS ( | ||
| Line 17: | Line 17: | ||
</pre> | </pre> | ||
| + | This is an example of the ANSI SQL technique of a recursive query. | ||
[[Microsoft SQL Server]] | [[Microsoft SQL Server]] | ||
