david.wright-948385 (4/27/2010)

---

Jim Russell-390299 (4/27/2010)

---

On the other hand...

One of the rules of extreme programming was "do the simplest thing that could possibly work."

There is some danger in adding code complexity to...

The point being made was that the procedure itself never actually gets called, so there's no need for a try/catch within the proc. As far as I can tell...

Steve Jones - Editor (4/23/2010)

---

Good to see some people doing this.

I'm torn on the disk space argument. It does cost $$, but so does people's time. If there are other...

What version and build are you dealing with in both scenarios?

Len is always supposed to return the result without the spaces (since it trims the trailing spaces). Are you...

WayneS (4/21/2010)

---

Well, keywestfl9 did say:

i have a requirement to find median of two date column...

For 2 exactly - the median is the average of the 2 numbers.

Since the import wizard is actually a SSIs package in wizard form, if you opt to not execute, but save instead, you can set up the package to only import...

CirquedeSQLeil (4/21/2010)

---

Brutal - these people are quite aggressive then -...

TDE does not hide it from the admins.

Grant Fritchey (4/21/2010)

---

Michael Valentine Jones (4/21/2010)

---

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any...

Paul White NZ (4/19/2010)

---

Not sure what you mean here, Matt....

Paul White NZ (4/19/2010)

---

Either, so long as it meets the requirements. ...

Jeff Moden (4/18/2010)

---

With a bit of egg on my face (a whole omelette, actually), it would appear that IDENTITY is, in fact, the culprit and not the 3 way CROSS...

Stefan_G (4/18/2010)

---

Jeff Moden (2/23/2010)

---

For those that add a triple cross-join... eh... wrong answer because behind the scenes, it will cause explosive growth of one of the log tables for big...

does the view include primary keys from both tables? Even if they're not used for anything else, this will help access "make sure" it know what record in each table...