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!

  • Congratulations IamaSherpa 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. dpdougla

    URL Mapping and Rewriting

    I am re-writing a web site converting it to asp.net. For now the main traffic will be to the Default.aspx page. The problem is that there are lots of urls out there in the search engines etc. where the format is like this: http://mysite.com/this-is-a-seo-friendly-url so when someone clicks on...
  2. dpdougla

    Outlook 2003 Calendar in asp.net app

    At this point my task is merely researching the most viable route to take considering our situation and circumstances. The only two things we are considering to add to the company's intranet site at this point would be a calendar (with Outlook data) and the ability to schedule appointments...
  3. dpdougla

    Outlook 2003 Calendar in asp.net app

    I have already asked this question on another forum and it was suggested that I post this question on this forum. So this is a copy and paste job. I have the task of creating user control (asp.net) that will access the logged in user's outlook calendar and display it on the page. This will be a...
  4. dpdougla

    Outlook 2003 Calendar in asp.net app

    I have the task of creating user control (asp.net) that will access the logged in user's outlook calendar and display it on the page. This will be a custom web page for the user when he/she opens the company's intranet site. I've done lots of work in vba (or whtever you call it in .net) but I...
  5. dpdougla

    LDAP Querying for Hierarchical results

    I realize that, but it is true that you can access AD through .net with LDAP. (The company's software is all done in asp.net) What I'll end up doing (I think) is populate a table with the AD data and query it from there. The only problem with that approach is that when active directory gets a...
  6. dpdougla

    LDAP Querying for Hierarchical results

    I am using a database table to list managers and people that report to them -- a parent/child relationship I use to populate a Treeview control. The problem is that this table is not kept updated so the data is incomplete. My boss has asked me to use LDAP to query the Active directory to get...
  7. dpdougla

    Return most recent rows in each group

    I experimented with a lot of different queries including some of the ones suggested above. This one using MAX DISTINCT worked perfect: Select assign_no, MAX(DISTINCT CONVERT(varchar, last_attempt, 101)) AS last_attempt, Status, MAX(DISTINCT DPD) AS DPD FROM Test GROUP BY assign_no, Status...
  8. dpdougla

    Return most recent rows in each group

    I get the results I want in MS Access using the first aggregate function, but this won't work in SQL Server (which is the back-end database I'm working with) MS Access query: SELECT First(Test.id) AS FirstOfid, Test.assign_no, First(Test.last_attempt) AS FirstOflast_attempt, First(Test.DPD) AS...
  9. dpdougla

    Return most recent rows in each group

    I have a data set similar to this: id assign_no last_attempt DPD Status -------------------------------------------------- 1 123456 12/31/2010 100 On Hold 2 123456 12/10/2010 50 On Hold 3 123456 12/5/2010 25 On Hold 4 123457 12/28/2010 90 Closed 5...

Part and Inventory Search

Back
Top