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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query based on latest date per user
I'm trying to pull some information from a SQL database. I'll explain a bit what the table is comprised of to better explain my problem. I have data inputed into the table from an audit that runs on a PC. Each PC has an workstation number and it records the date it was audited. Because each...- jay24k
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Programming
-
Inserting Date Time Into SQL...Help
I'm trying to insert the current date into an SQL database. I have tried the database field set to datetime and smalldatetime. I have tried using the commands date() and also building the date manually by grabbing month..etc. What is the easiest way to input a date into a datetime field... -
Help with script please - should be easy
I'm trying to replace all apostaphes and I can't get this to work. Here is my script. In what format do I need this in to be able to work? Right now putting the variable addtrain in there doesn't go in my database at all. Please assist :) <% Set Conn = Server.CreateObject("ADODB.Connection")... -
Export contact list in Active Directory to Access
I posted in LDAP but I don't think it can be done that way... I've searched everywhere and I'm unable to find it. Server is 2000 and Exchange 2000 as well. I have a OU Group that is primarily for special email accounts and mobile contacts where the contacts appear in the ALL Contacts listing... -
Help with Exporting Global Contacts to access database
I've searched everywhere and I'm unable to find it. Server is 2000 and Exchange 2000 as well. I have a OU Group that is primarily for special email accounts and mobile contacts. I've tried to pull those in a vbscript but that doesn't appear to work. What I would like is for the users in our... -
Active Directory - Delete SMTP values
I need to delete all the SMTP values in active directory and then I'm going to let it rebuild. We have several emails from an old domain that need to be cleaned out. Anyone know of a way to do this? I know I can update with the LDIFDE command in win2k server but I don't see where I could...
