I really don't have time to dig into this, work is a bet hectic. When I've got some spare time, I'll try to remember to revisit it. I'm fairly...

Sorry, I'd have replied sooner but things have been going on at work that take priority.

What you need is a recursive check through the list. So, I've knocked up...

You've been around long enough to know to provide consumable sample data.

Most of the answers to your questions are...

There's no question here 😉

However, I note that you're attempting an inefficient T-SQL splitter. Have a read through this article (http://www.sqlservercentral.com/articles/Tally+Table/72993/) by Jeff Moden[/url], for a better one.

Drove up to Nottingham for SQLBits this morning, checked in to hotel and then with nothing better to do went and registered. It's 7.30am and I've noticed that registration is...

BenWard (5/2/2013)

---

alas this table is built from daily data files going back over a number of months so getting the software house to re-export some of those csv files isn't...

leostrut (5/1/2013)

---

I have a table like the following:

Name Time1 Time2 Time3

leo 06:03 0615...

BenWard (5/2/2013)

---

ooh interesting... I've just checked again and all the 2011-01-01 type dates returned true by isdate (im expecting yyyy-mm-dd) are returning records where the dd part is between 1...

So, using this sample data: -

SELECT ID, Val

INTO MyInputdata

FROM (SELECT 1,'John Smith' UNION ALL

SELECT 2,'9/13/1961' UNION ALL

SELECT 3,'Phony...

Would you consider '2011-01-01 17:15:55' as YYYY-MM-DD HH:MM:SS or YYYY-DD-MM HH:MM:SS ?

Would you consider '01/01/1995 12:52' as DD/MM/YYYY HH:MM or MM/DD/YYYY HH:MM ?

SELECT c.id, c.brand, oa.color

FROM Cars c

OUTER APPLY (SELECT TOP 1 co.color

FROM colors co

...

SELECT a.id,a.brand,oa.color

FROM (SELECT c.id, c.brand, (ABS(CHECKSUM(NEWID())) % 3) + 1

FROM Cars c

)a(id,brand,colorid)

OUTER APPLY (SELECT color

...

Very interesting. I've been playing around a bit, here's my test script so far: -

USE tempdb;

SET NOCOUNT ON;

-- CONDITIONALLY DROP TABLES

IF object_id('test_Details') IS NOT NULL

BEGIN

DROP...

Is there any reason you can't just test it?

USE tempdb;

SET NOCOUNT ON;

IF object_id('#temp1') IS NOT NULL

BEGIN

DROP TABLE #temp1;

END;

--500,000 Random rows of data

SELECT TOP 1000000...