Not sure of the best location for this question, so I'm dumping it on the front step :)
I need pull a list of employee's from a table/view/list from Sharepoint for the user to select from a combo box. I'm not looking to integrate Sharepoint services with my web app, just pull some info from there. I've made some progress doing some sql queries, but by design Sharepoint isn't designed to be interfaced that way, and is intentionally convuluted to steer developers away from doing such a thing.
Ok Redmond...show me a better way then...
My query, which is incomplete but helps illustrate what kind of data I'm looking to grab, follows.
Select tp_DirName, nvarchar1 From AllUserData A
Inner Join UserInfo U On U.tp_ID = A.tp_ID
Where ...
Go to the complete details ...