n" <[EMAIL PROTECTED]>
To: "Jon Rosenberg" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 1:48 PM
Subject: RE: select query question
> create temporary table foo as select patientnumber, count(*) as rcount
> from source_table
> grou
I have a table where patient visits are logged each visit, the table is:
patientnumber,visitdate,location
I need to select and count the number of records that have 2 or more entries
with the same patientnumber
in sql-english:
select count(*) where there are two or more records with the same
pa
you need to grab the .i386.rpm files...you have the source code RPM.
- Original Message -
From: "Ben Ocean" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 10:14 AM
Subject: Upgrading
> Hi;
> I'm trying to upgrade to the latest distro. I thought I could simp
I wish, ERWin is wonderful!
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 6:41 PM
Subject: Data modeling tool
> As much as I love creating models by hand, my databases are growing to the
> point where I need a tool
Well, only use Access if it's a small project. I've used both MS SQL,
Oracle 7.3 and MySQL. My MS db is about 8 Gigs and I've only had to rebuild
damaged tables once in the last year...I just upgraded it to SQL server
2000, and it seems fine so far, as well. Oracle, I had bunches of problems
wi