Veronica Brown (4/16/2010)

---

Time off....definitely!

After a long winter or especially rainy spring, the first beautiful day, come in and say, "for a job well done or for your committment....go ahead and...

Steve Jones - Editor (4/18/2010)

---

I don't...

another common reason for "file not found" (OS error 3) is also access denied. Even if the pathitself is valid - if the service account taking this on does...

Steve Jones - Editor (4/14/2010)

---

I didn't write this earlier, but I tend to agree that mandates don't necessarily help. There are plenty of doctors that don't keep up, or that...

Also - does it matter which blocks get consumed first in the case of a tie? For example - if batches 1,3,6,8 each had 100 and you were looking...

CirquedeSQLeil (4/12/2010)

---

I have considered the masters degree a few times as well. Personally, I don't see the benefit as it relates to cost. I think I would rather...

Using UnPIVOT should get you most of the way there:

(Tossing in an ID oclumn so that you know which row you're dealing with need to be adjusted)

select id,count(cols)

from

(select id,...

Take a look at this article from Jeff Moden, read the "split" section.

http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

Since you seem to have a fairly solid delimiter pattern going, it should work well for your purpose.

Jeff Moden (4/12/2010)

---

Bill Kline-270970 (4/12/2010)

---

I work in a multi db platform environment. We use both SQL Server and Oracle. I'm just a newbie when it comes to Oracle...

I'd tend to agree with PaullB, you can get pretty far with ping. That said - if you're worried about the actual web site responsivenesss, then you'll need to...

Not to take all of the fun out of tihs - but is there a need to match up the two children? As in - the order can have...

RalphWilson (4/8/2010)

---

nelsonj-902869 (4/7/2010)

---

Take the time (and bite the bullet) to write a preprocessing module to edit the batch coming into your database and edit the darn field. Any record...

Yes - it's reasonably straightforward. You still end up with a design decision: build it assuming the file won't be there...

I would go for the SSIS fileWatcher idea unless the volume of files is too high. That said - Nicholas' code looks like it would be just fine as well.

We...

I play a DBA on TV?

Seriously, I am a data architect/senior developer/jack of several trades. I've performed the functions of a DBA in the past, and I tend...