Search results for query: *

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

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

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

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

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

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

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

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?

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

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

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

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