Alerter is a Service in Windows 2000 and I believe XP but don't have a machine installed readily available.

The problem is interger values produce integer results, at least one has to be a decimal to get a decimal result. Try

Select

Permnum,

ROUND(

( 

ISNULL((CASE When ST1Q1 <>...

Inner Join in most cases makes no difference when it comes to that except maybe if the was some ALERT (alias) reference. But that is something you have to play...

May not be the best solution but should work for you calculation try

(

ISNULL((CASE When ST1Q1 = 'N' Then Null ELSE ST1Q1 End),0) +

ISNULL((CASE When ST1Q2 =...

ZoneAlarm works quite well as far as the free version http://www.zonealarm.com but you are saying net send messages. Just turn off Alerter and set to Manual should fix that if...

Not to one up Jay here (sorry joke about another thread). But here is another alternative.

SELECT 

COALESCE(LTRIM(COALESCE(Salutation,'') + ' ' + FName + ' ' +...

quote:

---

I've been outdone once again. 🙂

---

Not trying for that . I think...

Just a thought after I left this but here

quote:

---

AND ISNULL(appt.deleted, 'N') <> 'Y'

---

Are we really...

Good additonal point Jay. Always helps when more than one person looks over code. After all this then it boils down to testing indexes and execution plans.

Sorry, I use the Procedure ADO command type not a string built from the SP. And the account doesn't have any access other than an occiassional view hit which would...

Ok, I understand if you are using injectable query strings that are built dynamically. But I wrap everything except a few views in SPs so I am covered. But I...

Ok, maybe I missed something all this time but I have never had a special character bother other than ' as long as wrapped in single quotes 'nnnnnn'. So what...

Oops, keep in mind the code listed in the previous is example based with notes and not fully completed. Make sure you read the notes and explainations to build proper...