Gianluca Sartori (5/22/2012)

---

Thanks everyone for the suggestions and opinions.

If everything goes well, I won't be working as a trainer any more.

I'm negotiating a contract as DBA/DBD. It's going to be...

Hi Lynn.

Just a reminder to all you paranoids out there:

We know who you are, and we're watching you.

Hey, good to see you again, Barry.

Lynn Pettis (5/9/2012)

---

Jeff Moden (5/9/2012)

---

Wow! Working with Oracle...

L' Eomot Inversé (5/3/2012)

---

Snarking is fair enough, but I hope "boojuming" is...

NO !!!

This one[/url] is.

Good point, Sean. I've will confess to being a really bad offender in the past. Nowadays, I post less, and then only if I...

This post intentionally left blank.

facturan.antonio (4/30/2012)

---

Hi guys.

I'm really grateful for all the help you've shared. Analyzing the formulas takes a lot of time for me to somehow grasp what does it do. ...

Here is a link to a blog by Isaac Kunen discussing "nearest neighbor" solutions using spatial functions in SQL 2008. (This query will actually become fairly easy in SQL...

Its not that nasty, it's a fairly straightforward parse, BUT....

Column

Home/Documents/Text/Files/

Home/Documents/Text

Home/Documents/Text/Files/XYZ.txt

Home/Documents/Text/Files/

Home/Documents/

There is no "Text" in the last line of your input, yet you want it to appear in your output.

It "Text"...

As a general rule, stay away from scalar functions, especially ones that contain SELECT statements. I assume this is what you are talking about because you want to...

Lynn, have you ever considered asking an OP to include himself in an execution plan?

Nice hat, Roy 😎