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!

Recent content by wfd1bdb

  1. wfd1bdb

    eliminating dups

    George, I have been analyzing your explanation and it is great. I went through and added the "clcharity." to the query to keep it straight in my mind so that eliminated the confusion. However, I am getting this error: Server: Msg 241, Level 16, State 1, Line 2 Syntax error converting...
  2. 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...
  3. 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...
  4. wfd1bdb

    top 1

    Borislav, This seems to work well and returns the MAX reported date but there are times when this reported date field is empty or null. In that scenario I also need that record. I tried to add a CASE statement: (but that did not work) Any help is greatly appreciated...now I am off to lunch...
  5. wfd1bdb

    top 1

    Borislav, yeah that works but I do not understand how! Using tbl1 and tbl2. That is new to me. Thanks!!
  6. wfd1bdb

    top 1

    Yes, the question is...where do I put this code? SELECT MyTable.* FROM MyTable INNER JOIN (SELECT a.account, MAX(c.rundate) AS Test FROM clchrge GROUP BY a.account) Tbl1 ON a.account = a.account AND c.rundate = Tbl1.DateField
  7. wfd1bdb

    top 1

    Here is my code! I have to admit that I am having trouble inserting Borislav's code because of the multiple joins alerady in the script. I have been looking at this for 35 minutes and am becoming bug eyed. Brad SELECT DISTINCT a.ACCOUNT, b.PLNAME, b.PFNAME, d .PROV, d .NAME2, c.status_id...
  8. wfd1bdb

    top 1

    Yes, it is the latest date. So something like: Select acct, lname, fname, max(date) oedre by max(date)
  9. 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
  10. 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...
  11. wfd1bdb

    modify date format

    Thanks Alex....that worked....you are making me look good!
  12. 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
  13. wfd1bdb

    CASE statement

    Does CHARINDEX('Yearly RR Required', clmastbcassr.RECOMMEND) mean find the character string 'Yearly RR Required' within the field clmastbcassr.RECOMMEND? If so how can I get it to find 'Yearly RR Required' and 'YYR Req' and 'Yearly RR Req'? Because users have typed in different string to mean...
  14. wfd1bdb

    CASE statement

    It can be NULL,,,it does not matter to the user.
  15. 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...
See more

Part and Inventory Search

Back
Top