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 Rhinorhino 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: wfd1bdb
  • Content: Threads
  • Order by date
  1. wfd1bdb

    eliminating dups

    I have problem. Below is a set of data I am working with and I only need the record with the newest date. I used this script with MAX(assessdate1) but I am still getting 2 or more dates. I thought if MAX is used then you would only get the most recent date. Thanks ahead of time for for...
  2. wfd1bdb

    help with exists

    Here is my code I am working on: Here is some background...I am looking at finding scheduled clients who have appointments in the future with a code of 'reentrmr30'. Of these people who have an appointment for a 'reentrmr30', how many do not have a flag of 'b' AND have not had a 'ev60' in the...
  3. wfd1bdb

    top 1

    I wrote some code that gives me these results but I only want the top 1 record for 177979. Not sure how to do this. Many thanks ahead of time. Brad 600630 DRYER DON 8/04/2007 177979 FOUNCH DONNA 8/10/2007 177979 FOUNCH DONNA 8/12/2007 177979 FOUNCH DONNA 8/14/2007 614283 GERDNER KEM 8/15/2007
  4. wfd1bdb

    SQL 2000 Enterprise manager Web Assistant Wizard

    I am trying to use the Web Assistant Wizard to run the script below and it is failing. it doesn't seem to like the (parentheses) or [brackets] or datediff. so I am not sure what to do. Any insight working with Web Assistant Wizard would be appreciated. wfd1bdb SELECT SSNO as AccountNo...
  5. wfd1bdb

    modify date format

    I am getting dates out of the db in this format: How do I get rid of the 08:22:00.000 from the date. I am using this cast statement: cast(reported as datetime) 2007-05-14 08:22:00.000 Thanks in advance for advice, Brad
  6. wfd1bdb

    CASE statement

    I have a relatively simple query except 1 field is a text field which users can either choose from a pull down or type the entry. The problem occurs when the users abbreviate what are supposed to be standardized answers because if they don't they will not fit into the field. For example: 'Yearly...
  7. wfd1bdb

    query format

    i AM RUNNING THIS CODE AND GETTING THE below results...the problem is I can't use the data because there too many fields for each Account number. I need 1 account number and have all the varcode fields follow it. SELECT COMPANY, ACCT, SECTION, VARCODE, VARTEXT, REPORTED FROM CLDICTIONARY AS...
  8. wfd1bdb

    Reporting Services SQL 2000

    I have copies of Sql Server 2000 and Reporting Services however, the only copy I have of Visual Studio is 2005, not the prescribed Visual Studio 2003. My question....will this make a difference?
  9. wfd1bdb

    Easy question

    The company I am working for is running SQL Server 2000 and we have a valid license for it (of course) but I want to install Reporting Services on our test SQL Server. Is there a seperate install disk that has Reporting Services on it. I have looked through our collection of CDs and cannot find...
  10. wfd1bdb

    Creating a Unique identifer

    I need to create a unique identifer from the values selected from 4 different fields. For example, I will query a db for a first name (pfname), a DOB (DOB), a gender (sex) and a Social security # (ssno). Select pfname, dob, sex, ssno from client OK...I need: the first 3 leters of the Pfname...
  11. wfd1bdb

    find missing bills

    Here is the issue: I have 166 accounts (I shortened the account list for this post to 6 and the cpt code list from 35 to 5)and need to find records where there is a note (Modality) but no bill (CLcharge). In other words, instances where our organization has provided a service BUT that service...
  12. wfd1bdb

    How to SUM a CASE statement

    I need to be able to sum a CASE statement and put that sum in a field [Charges]. Below is the code I have tried. It does not work and I get the following error. "Column 'A.CHGALLOWED' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...

Part and Inventory Search

Back
Top