How to get managers list
Thank you in advance for any feedback you may provide.
On the adventureworks database provided by MS Office they have on the humanresources.employee a field named organizationnode. Based on this field I would
like to get a list of all managers only. Please present me with the code I'm not too familiar with sql.
On the adventureworks database provided by MS Office they have on the humanresources.employee a field named organizationnode. Based on this field I would
like to get a list of all managers only. Please present me with the code I'm not too familiar with sql.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This certainly sounds like some type of classwork or homework. If so, we can/should only provide general approaches/ideas, not full code.
ASKER
It returned more than the number of supervisors, but it put me on the right track. Thank you.
where organizationnode like '%managers%'
Were the humanresources.employee is the name of the table, organizationnode the name of the row and '%managers%' the phrase you are looking for in that row. the % are SQL wildcards.