It's something I have to develop and I'm asking for another points of view.

Hi,
   no, it's not possible, the room must have the exact number of persons that allows.I've got a solution, not sure if it's the best. Here is it:

Right answer is an error. Problem is the space after the comma in the function. I want my point back! 🙂

Steve, thank you for your solution!! It works fine and, regarding performance, it's also ok. That was exactly what I was looking for.

Name of guest is not important. Think in a group of 10 friends, they can be in any room, grouped as they want. The only condition is to match the...

Here is an attached file with some sample. It's not the final solution but you can get the idea, I have a table with rooms that belong to an accommodation...

Thanks for the advice, Steve. Actually I was not trying to start a discussion and, to be honest, I was a bit surprised with his response.
I understand that I'm...

Ok, let's start from the beginning. Let's say I have a hotel with rooms. There are rooms for 2 persons, rooms for 3 persons and rooms for 5 persons. For...

Hi Joe,
    the values in the column, those comma separated, are as a result of a recursive CTE. Maybe  the original CTE is wrong and I've shouldn't get those...

Much better, you're improving 😉
Thanks, John!!!!

I like your solution, John, mainly because it's more generic. However, I was expecting to have an ordered list like 2,3,5 in the reconcat column instead of ,2,2,3,3,5,5. I'm trying...

I could fix the issue, changing the font size of SSMS. Maybe not the best solution but it worked.