Doh! Told you I was brain dead! 😉

AURGH!!!!

Also not what I was expecting.

We download data from a legacy system and we constantly find garbage like a date of 06/31/1997, a time like 08:75 am or...

Andrew -

I knew there was a simple solution but neither one of us could quite see it.

When Ly gets in and gives it a try with the...

Actually, we CAN have no exit time for the patient and we CAN have the exit time before the arrive time.

The arrive time is the time the patient...

Unfortuneatly, we need a solution for SLQ 2000.

Our DBA is working on getting 2005 on our test server so we can test the existing app, written for 2000,...

Found it. (It was "Twitchell" with a double "L" at the end.)

Nope, that doesn't help. It refers to an alternate location on my same machine, not a remote...

Do you have a link to the article? I'm not finding anything on my searches.

HIPAA = Health Insurance Portability Accountabilbity Act of 1996

Under "Wrongful Disclosure of Individually Identifiable Health Information," Section 1177 states that a person who knowingly discloses individually identifiable health information to...

I'm having a hard time figuring out what you want to do.

If you want all the rows to have ind=YES:

UPDATE MyTable

SET ind = 'YES'

If you want to update only the...

mike (10/22/2008)

---

In the code that generates the DROP CONSTRAINTS for the foreign keys, I can't get this to work unless I change rkeyid in the WHERE clause into fkeyid, which...

Ah ha! The center part of the 2000 join should be:

FROM HISAppt.dbo.sysUsers u

...

No idea. I'm not real sure what the groups are supposed to look like. Someone who is actually a 2000 dba will have to look at it. ...

Not at all. Please do. 🙂

Cathy

Adapted for SQL 2000

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa (http://challa.info)

and the database Roles that the user belongs to in all the databases.

Also,...