I generally look to see what the most common condition is. That condition gets the zero value. The abnormal condition gets the 1 value. Then I just name the column...

Thanks. I've done similar things with my shortcuts too.

Thanks for the insight.

Thanks for the question.

In the health industry we have the extra burden of keeping any Protected Health Information secure and the threat of government sanctions if we don't. Always working securely online and...

Luis Cazares (8/5/2014)

---

That's true, but this could work as a guide. This script was originated from a forum post and I thought of sharing it even if it can't be...

The task I have is to identify where in my daily sql I can use this.

Was looking for the trick.

Funny. I actually thought you had something there.

Some are good, some not so good.

UGH, we are just getting into hiring for IT again.

Yep, you always have to watch out for this.

Actually I kind of got lost.

aleksey donskoy (10/13/2015)

---

Awesome script. Works like a clock. Thanks.

You do not need to have a stored procedure there.

Made 3 modifications:

1. Converted it an ad hoc query using the sysprocesses.hostname column

2....

Thanks for the detailed article.