Search results for query: *

I am building a stored procedure against a SQL 2005 database and need some help optimizing the query. It will end up running several hundred times a day so I want to make it as efficient as possible. I ended up having to use temp tables to get where i was going, and that is what i would like...

I am working against a mssql 2005 db. I have largely tought myself sql, and as you will probably notice from the script below, I have lots to learn. The following logic collects encounters that need to be deleted, and then uses a fetch statement to accomplish the deletions. It works, but it...

I am working on a sql statement to collect the top 50 highest patient balances per provider. I am running against a MSSQL2005 db. At present I have the following, which returns the top 50 for the whole database, not per provider, how do I change this to collect the 50 highest balances per...

Im searching a sql database and trying to find where item A exists, but item B doesn't exist. so far I have something like the following: select c.enc_id,s.sim into #one from charges c where c.sim in ('list of serveral sim codes') that gives me a temp table with the encounter ids and the...

I have a windows 2003 standard sp2 server, that appears to be having a problem. The Directory Service log shows the following errors, over and over again. First error: Date: 9.9.2007 Time: 8:47:51 AM Type: Warning User: N/A Computer: LRDCDC2 Source: NTDS Inter-Site Messaging Category...

I am working on a stored procedure to export data from a sql 2005 database. I would like to have the stored procedure create a new table in the database, and then populate it. I am planning on creating a job to have the stored procedure run once a month, and would therefore like the table...

I have about 30 users with roaming profiles in my Windows Server 2003 Active Directory network. I want to move the location where the profiles are stored from one server (a db server) to another (my AD controller). Is there a problem with having roaming profiles, or home directories, stored on...

I am building an internal page and would like to have a form field on the page automatically populated with the windows user information. How do I get FrontPage 2003 to query active directory? Additionally, I would also like to find a way for a field to do a lookup without having to have a...

I am building a CRXI report against a stored procedure on a sql2k db. The stored procedure is quite simple, and has three input parameters. I want to build a dynamic list for the user to pick from to satisfy one of the parameters, but I cannot find a way to accomplish this. I need the...

I would like to find a way to password protect a bat file, so that when it is executed, the first thing it does is require a password to go any further. Anybody know how to accomplish that? MH

I have a Windows 2003sp1 server running FrontPage Server Extensions 2002 that hosts my Intranet site. I noticed on the Microsoft website that SharePoint Services 3.0 has been released. What is the difference between FrontPage Server Extensions 2002 and Sharepoint Services? When I click Start...

I am running Exchange 2003sp2 on a W2k3sp1 box. Presently, when my users access the appropriate url, they are prompted for login information. They must then login with 'Domain\User\ and 'password'. I have seen an Outlook Web Access signon screen that appears to be a microsoft product. It...

I am running Exchange 2003 sp2 on a Windows Server 2003 standard sp1 box. I am in the process of configuring Sender ID filtering and Inteligent Message Filtering (IMF). In the process of this, I have discovered that I have almost 3000 files in my queue directory located at "C:\Program...

I am using cr9 against a sql2k db. I am building a report that will generate appointment reminder cards for a medical clinic. When the report is run, it should print the cards on printer1 (epson dfx5000+), and the report on printer2 (hp 4250tn). How do I format the subreport to be on standard...

I am trying to build a bat file to automate the process of renaming a network computer. I can use the netdom utility included in the xpsp2 support tools to accomplish this, but I would like to tweak the basic command to allow me to enter the 'old computer' and 'new computer' names when I run...

This is probably a stupid question but here goes anyway. What is the best way to have several (3 or so) people check the same email address. I would prefer a scenario where all three people see the email, but when any one of them mark it 'read', it shows 'read' on all three. I additionally...

Does anyone have any experience getting a Java app to authenticate against an Exchange03 server? I have a small command-line app that will not auth. The debug info is below. I changed the names to protect the innocent. Any help is much appreciated. Thanks, MH EmailSender: Start DEBUG...

I am using Cr9 against a sql2k db. I am building a label report to generate patient labels. The scenario is when a doctor leaves, we need to be able to query the database and print one label for each patient who has been to see that doctor in a given period of time. I built the report, and...

I hope this is the correct forum for this question. I have some files that I need to both copy, and move. Files will be downloaded from a digital dictation device to Folder A. I need to copy them to Folder B for backup, and then move them to Folder C so a seperate utility can move them...

I have a problem with email occasionally getting rejected by sorbs. I get an undeliverable message back with the following message: There was a SMTP communication problem with the recipient's email server. Please contact your system administrator. <email.int.lrdc.com...