Hello,

It's during open hours 8am to 6pm, so it's 8am/10am/12am/2pm/4pm/6pm.

Regards

Hello,

I have the list of hours part allowed :

08:00:00:00.000
10:00:00:00.000
12:00:00:00.000
14:00:00:00.000
16:00:00:00.000
18:00:00:00.000

I want to fix datetime in my database by these hours....

The logic is that I made a void function to find start and endpoint of each lines.

But the way isn't correct because for the line 'E', the link...

I update the SQL, it was some postgresql, but I'll copy the structure to obtain the same result at the end

Hello,

I forgot to mention that varchar for dates are datetime in my production environment.
My database structure can't change because it's use in production and receive 1000 meetings...

Hello,
I want something like :

There are last ids, last -x ids and last '@@x' ids.
The @@2 is when someone change the order a little bit, the system create...

Hello,

The result of your query is good.

But as I want the last -x with the '@@1' part, I set the select like this :

Hello,

With outer apply, the execution time of my query reduce by 90%.

I still have an issue about one subquery, I'll add it monday, because i'm not...