Search:

GOT IT!!!!!!



SELECT account, patientname, DOS FROM testtable
WHERE DOS >= '2009-7-1' GROUP BY account having count(distinct dos) > 1

I'm using mysql for this.

I made a quick test table to try some things and put in the following data

100 bob 7-5-2009
100 bob 9-27-2009
101 greg 8-25-2009
101 greg 8-25-2009...

Can someone check my logic please,



SELECT DISTINCT Account, PatientName, DOS, Race FROM Visits
WHERE DOS >= '2009-7-1' AND (Race=1 OR Race=0)
GROUP BY Account, DOS
HAVING COUNT( Account...

I guess this was a bit tougher than I thought.

Just in case anyone is interested, I solved this by using PHP to run a query to get all my patients that have been seen since 7-1-2007 and then as I...

This is probably extremely simple for someone who does this on a daily basis, but it’s got me stumped. I've started this project early so I can hopefully learn as well as get the job done on time.
...

The company doesn't exist anymore dbasnett, there is no one to call. If someone thinks I'm trying to do something illicit and decides not to help me, then so be it. I certainly wouldn’t want anyone...

I have a very old patient management system and one of the reporting tools requires a password. Unfortunately, no one remembers it. I need a brute force method to crack it.

The password isn't any...

I havn't done it, but isn't it pretty easy to use activesync to transfer sql compact data to a desktop server? Is there some reason the data has to be stored in text files instead of a database?

I was just coming here to say I figured it out when I see I have two answers already. Thanks guys, I'll give your suggestions a try as well, I'm always happy to learn multiple ways of doing things. ...

I have 3 tables, here are the tables and relevant fields.

Events: (num, primekey)EventID, (text)EventName
Member: (num, primekey)MemberID
MemberEvents: EventID, MemberID

Here is a working...

What I've done a couple times for some survey data we needed to collect is build a simple set of ASP.NET pages (hosted on a web server in our DMZ) that can be accessed through a PDA's web browser and...

I've done several mobile projects over the last couple of years both for windows mobile and blackberry and I've learned that the very first question to ask yourself is, can the data needed be easily...

Actually, I'm using Access :sick:. As far as I can tell, access doesn't support CASE in SQL statements. I have been able to get the same functionality however using SUM(IFF(Active=1,Then...

If I have a table that has 2 fields, one is boolean and the other contains integers; is it possible to add up all the "True" integers and then subtract the sum of the "False" integers from it?

Worked Like a charm, that's exactly what I was looking for, thanks!

Hey guys,

I've got 2 tables, one is for incoming product, the other is for outgoing product. Both have a date field to show when product has been received or gone out. I need a report that will...

You can use VS to write apps for a blackberry, but you cannot use the .NET framework on the blackberry or write your code in VB or C#. I don’t know if you can even use it for drag and drop interface...

Thanks SpudGun77, but I can't use ISNULL like that in access, but after a couple google searches on the error I was getting from ISNULL, I found the access equivilent as a built in funciton...

SELECT MedicationTable.MedName, MedicationTable.MedDescription, Sum(ShipmentTable.ShipQuantity) AS SumOfShipQuantity, Sum(PrescriptionTable.PreQuantity) AS SumOfPreQuantity,...

Excellent!

I've modified the query and added outer joins and now I get all medications found in the MedicationTable even if they don't appear in the ShipmentTable or the PrescriptionTable and it...

I have 3 tables in access, * denotes primary key:
MedicationTable-*MedicationID, MedicationName, MedicationDescription

ShipmentTable-*ShipLotNumber, ShipDate, MedicationID, ShipExpDate,...

Thanks Si, I was considering adding an expired field to the incoming table, nice to get some conformation that it's a good way to go. That query was what I was having a hard time getting my head...

I've done a lot of database apps in the past, but they were always information gathering and reporting type projects. Once data went in, it never changed and was only used in calculations or to...

I played around with blackberry programming a few months ago.

You use a combination of javaME and the blackberry API. I used the blackberry IDE, but you can use other IDE's if you want. You...

The agency I work for wants to start making more use of SharePoint and trying to make a move to using less paper forms. We have 2008 SBS (SharePoint 3.0?) with about 25 workstations and 30 staff...

Thanks Gary, but when I try to execute the query, I was getting errors. I tried to modify it to this:



SELECT * ,Count(*) AS NumOccurances FROM PatientTable INNER JOIN ChargeTable ON...

Thanks riteshjain1982, I switched to this format because the inner join wasn't working either. I changed it to like '%250' and I'm getting results now, but it's returning every instance of '%250'...

Ok, I did some reading and searching and tried to go at it on my own. Can someone tell me why this query isn't returning anything?



SELECT * FROM PatientTable, ChargeTable
WHERE...

Thanks again Si, I should be able to modify what I have now to get the rest of my populations.

Even though the SQL part was very frustrating at first, it should make running these reports MUCH...

AHHHH got it, forgot the quotes.

DOH, it's been a long day and I'm getting tired.

I corrected the error and added the = sign, but SQL server still doesn't like it and says there is an error near 250 in the string. I need any...

Thanks again Si, I edited my orginal post so that it leads off with the database info.

your query structure worked great again and I now have the first batch of patients in excel.



SELECT *...

MS SQL server 2005 express

Hi again and thanks for all the help on my last question. I thought that I would be set once I had the list of PatientNumbers and would be able to handle it from there,...

Ok, this is just scary,:sick: I want to be able to do that in less then 30 seconds myself. Can someone recomemend some good reading material?

I don't have to do stuff like this everyday, but at...

I have 1 table that contains the patient number and the date of a patients visit.
columns:

PatientNumber
ChargeDate

How do I write a query that will select all the patient numbers who have...

This is the exception I get when trying to fill a dataset. It fails on da.fill(dtCharge)

System.Data.Odbc.OdbcException
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,...

Thanks riteshjain1982, that got me past the the first error and the reader.read() command executes without errors.

However, when I try to read any of the values that the reader is pulling, I get:...

I'm back to working on an old project that I had hoped I wouldn't have to deal with again.

I have an old database that my clinics patient management system is based on and I would like to...

Thank you jmcilhinney, I appreciate the information and accept the doco admonishment.

In the past I've tried many times to read the documentation for objects that I wanted to use in my program,...

I can't believe I'm having this much trouble with this, but I can't find a single code example of how to read the contents of a specific cell in the datagrid view.

The DGV is bound to a dataset...