Thank you sorted

Thank you guys for your response.

Alan loved your example.

Many Thanks for the reply - it really worked for my results set, please can explain the below section of the code for my understanding:

NUMBERED_INSTANCES AS

(

SELECT

...

Many Thanks for your reply

declare @StartTime nvarchar(10)= '12:00'

declare @EndTime nvarchar(10)= '12:45'

declare @Diff time(1) = cast(@EndTime as datetime) - cast(@StartTime as datetime)

select EndTime, StartTime, @Diff from times;

-------------------------------------------------------------------------------------------------

So instead of hard coding the StartTime and...

Yes you are right Phil and good habits make code easier to read. Thank you guys.

Hi Phil,

Why do I need the word Clustered at the end? I've never seen this before.

cheers

Hi Phil,

What does the number 1 represent in brackets for the time data type - time(1)?

i.e. declare @Diff time(1)

Thank you guys, you have been very helpful.

thank q