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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.