Tony++ (11/19/2009)

---

As shown in this QOTD, adding/subtracting a number from a date is adding/subtracting that many whole days.

Is this standard behavior, or is this undocumented behavior that could...

Thank you, Adam-424116!

This seemed so strange that I had to check and sure enough, even in Office 2008, Excel...

So I'm trying to keep up with the Thread and ended up falling out of my chair laughing with the denouement of this conversation from a couple...

psssst..... Don't feed the troll.

I realize I'm a bit late to this discussion, but have to vent a bit...

1. Yes, I've submitted QOD's and have suffered the slings and arrows of outraged point-seekers and...

Christopher,

You're absolutely right. I feel a bit embarrassed, but have to agree. Your counter example is actually in the list as option 1, so I have no excuse.

So,...

Michael Poppers (11/9/2009)

---

Noticed that, but since the PRINT statements utilize 1...

I've been kept busy lately with real work. Not that y'all missed me, but just spent more time than I should admit catching up with the Thread and now I...

Tom.Thomson (10/29/2009)

---

A good fun questioon.

But I think it's a terrible pity that SQL Server is this forgiving - it would be better to treat such horrid, unsightly and unreadable code...

Phil Parkin (10/29/2009)

---

:unsure: How disappointing. I still think magic...

I don't understand how this is a problem. Is there more to what you need than just a list of filepaths where a filename is found? What do you...

There's been a lot of interesting discussion here, but now I'm curious what Volkan, the author of this QOD, had in mind. Was it to show that CONVERT could...

Bob Hovious 24601 (10/25/2009)

---

Good question and interesting result. I'm surprised that it accepted mixed dots and dashes as separators in the date. I thought it would...

First of all, there's no such thing as magic or ghosts, not even for SSIS package files. The old package file is still whereever the job is told to...

Another bit of info that will help you get a useful response would be why you need the file list to begin with. The first thing that popped into...