Robocat.

Kills 99.9% of all known rodents.

Doesn't dig small holes in your neighbour's herbaceous border.

SELECT CAST(0 AS DATETIME) -- = '1900-01-01 00:00:00.000': 0 expressed as a date, the base year, see

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/3b078d5b-526c-4884-906a-e4442805795f.htm

-- what day of the week is the base date?

SELECT DATENAME(dw, CAST('1900-01-01 00:00:00.000'...

Jon, think of the benefit - a new way for you...

Today's Random Worm!

The Velvet worm.

Paul_Harvey (6/16/2010)

---

Thanks very much for your assistance, Chris. That works great.

I prefer to use query 2, as I can understand it. I am not too sure on how...

Paul White NZ (6/16/2010)

---

We scored a goal and drew!!!!

WOOT!

:w00t:

Thanks to everyone that posted congratulations. 🙂

I'm thinking Italy should be no problem now. Do they even play football/soccer over there...

scott.pletcher (6/15/2010)

---

Jeff, you can over-engineer, I'll give you that. Huge amounts of wasted I/O to no purpose. But you feel good about it, and obviously for you that's...

Garadin (6/14/2010)

---

Martin,

Chris was suggesting this book:

http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Dummies/dp/0470224657 You can pick it up online. You can also get all of the books I listed on Amazon.

The Understanding and using APPLY...

Itching

Yeah that's awesome, thanks Steve.

This is what I'd do: break each string into words (as columns) using the string-splitter of your choice. First delimiter is space-backslash-backslash, subsequent delimiters are backslash....

Edit: job done. Thanks Gail.

Hi Steve

Any chance of laying this out visually, mate? I reckon I know what you mean, but a picture would really help.

Cheers

ChrisM

scott.pletcher (6/14/2010)

---

Jeff has made two significant points here, that the challenges are unrepresentative of real-world coding and also that they may not be the best means to advance the capabilities...

scott.pletcher (6/14/2010)

---

Sigh. Consistently all you want to offer is pompous air.

Perhaps you could a few more self-important quotes to your signature so that you could acutally take up a...

I don't think so, there's only one target of an INSERT INTO or INTO...FROM