Sussed it!

The first part (US date format) i've done a SET DATEFORMAT dmy
The second part, I've made it cater for both dd/mm/yy AND dd/mm/yyyy:
[code...

I have a problem with this now...If the date in the note is in UK format, it returns NULL. (It works as expected when it is in US format).
The...

That works great Steve...Thankyou.
I had done the last part this way:
Yours works just as well 🙂

SELECT @combinedString = COALESCE(@combinedString + CHAR(13) + CHAR(10), '')...

Thanks John. Sorted :- 

DECLARE @Contents varchar(4000)
SET @Contents =
'abcdef 01/01/2018 08:15:13 This is a note , this is a note , this is a note...

Perfect. Thankyou very much

Thankyou so much John....But....you're going to kill me!!
I posted in the wrong section. Its 2008 (not 2012).
Is there a substitute for LEAD?...Sorry!

Highly unlikely John. I am going to make the assumption not

Hi Shanu,

I'm really sorry i did not reply to your message straight away.

I did get it all working in the end. Very similar to the code above.

If you need the...

ah sorry. Here's the code i used to create the initial calendar table.

Its 2 functions and then an SP. Most of the code i found on this forum and just...

Thankyou Andrew,

that makes perfect sense...and so very simple (when you know how!)

I don't know though how to populate the new field with an incremented value.

Can you help with this or...

Hi, Thankyou for your reply.

I have changed the calendar table so that it now has a BIT field for IsWorkingDay.

I dont really have any code that would make sense to...