I have a table with a list of employees, I also have a clr table valued function that will return all of the ad groups that the user is a member of
I want to create a query that will return a list of all users and there groups.
so if my employee table has
If I want to get the groups from my clr function I can do
select * from dbo.LdapGetAllUserGroups('jono')
this would return
What I would like to do is write a query to get all the groups for all users not sure how to do this
one has a