Thank you for your input

I was hoping for a quick resolution. But i guess tou ar right i need to develop an algo.

Thanks for all the help

Cheers

Thanks Phil for your time.

Cheers

For explanation, run the following:

DROP TABLE IF EXISTS #Custom;

CREATE TABLE #Custom

(

Noseqtrt SMALLINT NULL

,CUST_ADDRESS NVARCHAR(100) NULL

);

INSERT #Custom

(

Noseqtrt

,CUST_ADDRESS

)

VALUES

(1,'21 Beauchamps'),

(1,'29 Beauchamps'),

(1,'33 Beauchamps'),

(1,'33 Beauchamps'),

(2,'272 de la Presquîle'),

(3,'288 De La Presquile'),

(4,'311 De La Presquile'),

(5,'288 Des...

I already tried something similar. But, it does not work.

Cheers

To Phil,

The order on the same stop is not important except for the siblings.

the goal is to put them on the same seat if they are more like 3 then...

The customers are students boarding a bus so if at one stop i have more than one of the same address then i have siblings and they must sit on...

That column can be ignore i guess.

Cheers

OK the thing behind it is COVID-19.

The customers are students boarding a bus so if at one stop i have more than one address then i have siblings and they...

Here is the DDL:

CREATE TABLE [dbo].[CUSTOM](

[Noseqtrt] [smallint] NULL,

[CUST_ADDRESS] [nvarchar](100) NULL,

[ADDRESS_COUNT] smallint NULL,

[RANK] [int] NULL

) ON [PRIMARY]

INSERT INTO [dbo].[CUSTOM] (Noseqtrt,CUST_ADDRESS,ADDRESS_COUNT,RANK)

VALUES (2,'133 Du Croissant-du-Bourg',1,1)

INSERT INTO [dbo].[CUSTOM] (Noseqtrt,CUST_ADDRESS,ADDRESS_COUNT,RANK)

VALUES (2,'1440 des Roses',1,2)

INSERT INTO [dbo].[CUSTOM]...