sturner (6/26/2012)

---

GSquared (6/26/2012)

---

Shall I continue? Or just read the Constitution and you'll see a list of the critical services and enforcement needs. It's very finite, though subject to...

jbnv (6/26/2012)

---

patrickmcginnis59 (6/26/2012)I'm pointing out that you have not addressed the free market response to a visibly bad actor. There very well could be an answer here, thats why I'm...

sturner (6/26/2012)

---

archie flockhart (6/26/2012)

---

Or you need to accept that there are some things...

Agreed. This isn't a video game, where undocumented "easter eggs" are fun to discover. It's supposed to be an enterprise-level toolkit for managing data.

Imagine if you bought a...

You're welcome.

Jan Van der Eecken (6/25/2012)

---

Unless they coded ISNULL(a,b) as a wrapper around COALESCE(x1,x2,...,xn), which I would probably have done, just from a maintainability point of view. Then ISNULL should actually...

I'd need to see the code for the triggers and the create scripts for the tables, before I could offer any help on this.

Nah. It's a perfectly good question.

Another thing to keep in mind about IsNull vs Coalesce is that Coalesce is ISO-standard SQL, and has some slight advantages because of that.

However,...

Matt Miller (#4) (6/25/2012)

---

GSquared (6/25/2012)

---

Actually, if you define "NULL" as "unknown value" as opposed to "no value", then one could define a nullable char(1) column as "we may not know...

I'm not sure "we" are the right people to be marketing this career. Maybe "we" are, but doesn't that sort of get into the whole guild concept (master/journeyman/apprentice, and...

There are options beyond GetDate that may be more appropriate. Check here: http://msdn.microsoft.com/en-us/library/ms188383.aspx

Some of them include the time offset from UTC, so you can easily use those for EST/CST/EDT/CDT/Arizona-time/etc.

Matt Miller (#4) (6/25/2012)

---

GilaMonster (6/25/2012)

---

One byte in the...

I'm going to recommend doing this in something other than T-SQL. Like a .NET assembly. Where you can use RegEx functionality for it.

However, if you insist on doing...

Matt Miller (#4) (6/25/2012)

---

Brandie Tarvin (6/25/2012)

---

Matt Miller (#4) (6/25/2012)

---

SQLRNNR (6/25/2012)

---

Sean Lange (6/25/2012)

---

Or the...

L' Eomot Inversé (6/20/2012)

---

The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

But I may not find...