Thanks a lot!

To be honest, I don't understand a thing in the first solution. I already saw this

...select row_number() over (partition by...

somewhere, but I simply don't know what it does....

Wow! Thank you. Ok in meantime i did the update without variables, but I understand what you mean, and how to use these variables. Lessons learned! 😀

Sorry for the late response, I was struggling with another issue in our production Database today, so I haven't found the time to come back to this forum yet.

Thank...

YES!!! Strike!! :w00t:

Monday morning, back to work, and straight back to my database problem. With a little bit of customizing to your proposals everything now works as expected.

Thanks...

Thanks again Jack!

And yes, I've also noticed the "between" Problem. But because my Application originally sends varChars as Parameters, it's easy to add " 23:59:59" to the given String...

Thank you both!

I'll give it a try immediately. But I'm still confused about the order of converting parameters an building up the queries. That is because I first have to...