Just wondering where we're at with this. I'm happy to send more data, if needed.

You make a good point. We need to keep counting hours for the VisitID until we get a DISCHARGED status.

My thought is if someone is registered at 10PM on 11/1 and no other status is entered until 2AM on 11/2, I still have distinct date and hour. So, with...

It is possible that the patient entered the ER on a previous day. However, I'm focused on one day in order to work out that piece. I don't think it...

Thanx for your input. This is a Medicare 2 midnight rule report that I'm creating. I knew there would be an issue with someone being admitted at midnight but, the...

Pardon my ignorance

Thanx

Could that be accomplished by redeploying it?

I found the author, Ben Gribaudo. I'm not sure you understood my issue. I have several hundres stored procedures and only a little over a hundred show up in the...

Nice. Thanx.

Touche. Thanx

Thanx for the reply but, that's a bit more involved than 8 replace statements.

Good point. Thanx.

I'll give it a shot. Thanx.

Thanx for your help.