Thanks Jeff for your time and help in answering,  I will experiment a bit with this technique!

• This reply was modified 5 years, 5 months ago by  joe-584802.

I've been having a play again and have come up with the following trigger which seems to work.

CRAETE TRIGGER [dbo].[updateDateTime]
ON [dbo].[tblFuelRejection]
AFTER UPDATE 
AS UPDATE tblFuelRejection 
SET DateTimeStamp...

Thank you, that fixed it.
Much appreciated!

Joe

Hi there, thank you for the replies and also thank you for the comprehensive information on the DelimitedSplit8k_LEAD by Eirikur Eiriksson, a nice bit of bedtime reading! I was using the...

Hi Guys,
Apologies, I think I have posted this in the wrong forum., it should have been in the TSQL forum, anyway I started so I'll finish...

I persevered...

John,

I've just run some tests with your revised script and it works exactly as I was hoping.

Thank you so much for doing that for me, greatly appreciated!

Regards.

Joe

Hi John, I didn't realise that I could have just leave the logical name as is, I thought by doing that it would be an identical restore in every respect...

I'm probably not using the correct terminology. Maybe 'like' would be a better term.

I was hoping to do something like this...

UPDATE [Table2]

SET [CCode] = (SELECT [CCode] FROM [Table1]...

Hi Kevin, I didn't realise that there was such an issue in using a scalar function, the database that I'm using is not using huge record numbers so I thought...

Thanks for the improvement Lynne, I'm guessing table valued functions are more efficient than in-line scalar valued functions?

Thank you so much for the replies this is what I ended up doing as a Scalar-Valued Function

CREATE FUNCTION [dbo].[GetHarvestYear] (@InputDate datetime)

RETURNS int

AS

BEGIN ...

Thanks Eirikur, that's awesome...!

Thank you for taking the trouble to give me such a comprehensive example, you've given me another road to go down which I'll pursue.

You are all so...

Thank you so much guys for your useful tips and SQL snippets.

I will follow your advice and create a pre-populated calendar table, it makes total sense.

Cheers!

Hey Piet thank you for your prompt reply.

Does that mean I have to create a calendar table that's already pre-populated with dates?

Is there not a way that TSQL can...