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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: mholbert
  • Content: Threads
  • Order by date
  1. mholbert

    Optimize Sql 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...
  2. mholbert

    Cleanup My Logic

    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...
  3. mholbert

    Top(50) Per Provider

    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...
  4. mholbert

    How to create a Does Not Contain query

    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...
  5. mholbert

    NTDS Inter-site Messaging Errors

    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...
  6. mholbert

    How do I Create a Table with a variable name

    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...
  7. mholbert

    Moving Roaming Profiles to a different Server

    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...
  8. mholbert

    Query Active Directory in Front Page 2003

    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...
  9. mholbert

    Dynamic Parameters

    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...
  10. mholbert

    Password protect a bat file

    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
  11. mholbert

    SharePoint Services 3.0 vs. FrontPage Server Extension 2002

    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...
  12. mholbert

    OWA Login Screen

    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...
  13. mholbert

    3000 files in Queue folder

    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...
  14. mholbert

    Different size paper for subreport

    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...
  15. mholbert

    creating bat file that requires user input

    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...
  16. mholbert

    Newbie Question

    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...
  17. mholbert

    Java App won't authenticate email against Exchange03 server

    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...
  18. mholbert

    Label Parameters and Distinct

    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...
  19. mholbert

    Robocopy complications

    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...
  20. mholbert

    Sorbs Problem

    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...

Part and Inventory Search

Back
Top