This is a variation on packing intervals.  You can read more about that at New Solution to the Packing Intervals Problem.  You just need to use the desired tolerance...

Spam reported.

Yes, the problem is here.

AND ((M.IDHuis = @IDHUIS) or (@IDHUIS = NULL))
           AND ((H.IDAfd = @IDAFD) or (@IDAFD = NULL))


NULL...

I believe that the following article addresses this topic, or it should at least get you started in the right direction.  Solving FIFO Queues Using Windowed Functions

You've posted this in a T-SQL forum, but this is not T-SQL.  I'm guessing SSRS.

Drew

I would use QUOTENAME instead, because it will handle input data that contains apostrophe's.
Select 'Update mick_settings Set setting_value = ' + QUOTENAME(SETTING_VALUE, '''') + ' Where SETTING_NAME...

You should be aware that the regex syntax changed dramatically from SQL 2014 to SQL 2016.

Also, keyboard shortcuts vary depending on the keyboard mapping scheme. Occasionally, my...

Pictures of your data do not help.  Please post scripts of your sample data as outlined in the first link in my signature.

You're sample data does not include...

Reported as spam.

Sample data and expected results, please.  You can find a link in my signature that explains how.

The best way to do this is with a computed column, but...

"Are all cities covered" is a much simpler question to answer than giving you all possible combinations of values.  I did write a recursive CTE to answer this question, but...