Thanks a lot Brad for your answer ... A french expression says: "I'll fall asleep cleverer this evening" 🙂 Thx

sorry for this maybe stupid question but what does "moving to the cloud" really mean?

Is it outsourced data storage?

Thanks for your replies

Good introduction! Looking forward to reading part 2 (+1).

And totally agree with Kev. I only want to add that nobody is asking anybody to fire their cursors if they prefer...

I was declaring a table (@fnfev), not creating a temporary table (like #fnfev).

For my needs a temporary declared table was the best in terms of performance.

Thanks Sergiy.

It was definitely a stupid AS error ... 😉

Hi,

Why don't you use the CONVERT function?

Following code should return the time in format hh:mm:ss in @time

declare @time char(10)

select @time = convert(char(10), @your_date, 8)