Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RohanWest

    Recursive Query

    Hi back again, That code you gave works great if i need to know all the managers. I only need to know about managers that are above that user. Any ideas? Rohan
  2. RohanWest

    Recursive Query

    that works great cheers!
  3. RohanWest

    Recursive Query

    Thanks, i have just been thinking about it and your right, you would have to specify the number of levels in order to know how many joins to create. I think that i will create a stored procedure and use similar code as you said... Thanks Rohan
  4. RohanWest

    Recursive Query

    The thing is the manager and user table is the same table there has to be an outer join some where here are the fields of the table UserId ManagerID UserName The manager ID points to another UserID
  5. RohanWest

    Recursive Query

    Hi there I have a table that look like this it contains user names User +-------------- Paul Dan Peter Simon John Each user can be a manager of a different user. I have written a query that shows who manages who User Manager +--------------+-------- Paul Dan Dan Peter Peter John Simon...
  6. RohanWest

    RecordSet.Find not there?

    Hi there guys, i have just started working with InterDev and i have been having a few problems, At the moment i have made a new project on a server called testintranet, i have also set up a connection to a SQL server. This is working fine. On the main page i have got a GridDTC which uses...

Part and Inventory Search

Back
Top