I'd say both are grills here in the U.S.

Your welcome. Just note that is only works for 2 rows per med_rec_no and doesn't take into account the likelihood for a gap in times. The code assumes...

Luis Cazares (10/22/2014)

---

I really feel bad for this guy. He keeps posting weird problems about SPs full of bad practices. I'm sure that he isn't the problem and the problem...

katland226 (10/22/2014)

---

Well, I just realized that the message is indeed printing... But instead of printing the message in the results tab, it instead prints in the messages tab.

Okay, so it's...

The key thing that Gail is asking, is what are you using to run the query? If you are using a .NET application that you are writing to run...

Can you tell us how you know which is the current patient type and what defines a distinct visit in this scenario? I think something like this might work,...

@rowcount should be a variable within the procedure not a parameter of the procedure.

BWFC (10/22/2014)

---

We had 80 odd people at the show in September so a whole pig could well be worth it. I've just got to convince a couple of people...

If you have enterprise edition.

Backup up the log does not cause it shrink. Backing up the log marks parts of it to be available for re-use. You must run a DBCC SHRINKFILE...

Can one of the corruption guru's take a look at this post, http://www.sqlservercentral.com/Forums/Topic1627263-2799-1.aspx, and help the guy out. I asked a couple of questions, but I haven't dealt with...

Do you have anything else on this box?

I'd check the storage sub-system as it sounds like you have a bad disk and rebuilding the system databases put them back on...

For your first error, are you getting this for all queries or a specific query? If a specific query or queries can you post them (anonymized as needed)?

For your...

Could be the firewall blocking smtp connections or the mail server itself not allowing smtp connections.

spaghettidba (10/21/2014)

---

Hi!

It's been a very long time since I last posted on THE thread...

Actually it's been a very long time since I posted regularly on the forums, but now I...