create table #testing(
[order] nvarchar(100),
country nvarchar(100),
colour nvarchar(100),
amount int
)

insert into #testing
values('testingOrder1','UK','red',10),
('testingOrder1','UK','red',20),
('testingOrder1','UK','red',30),
('testingOrder2','US','blue',50),
('testingOrder2','US','green',50)

select * from #testing

how can i count distinct partition...

I have the following code to concatenate all distinct Aliasnaam per Masjien.

SELECT [Masjien], aliasname = STUFF((    
...

Just for fun I thought I'd throw in a solution that leverages NGrams8k. This will...

It would appear that the ID is only unique to the table it is used in...

Be careful here, this query will ignore any missing records in the destination table.
😎

Here is...

missing index as per explain plan might help a bit there.

you could try changing the index to...

Thanks Jonathan for you replay.
Unfortunately this solution is not working too.
"Msg 156, Level 15, State 1,...

This is an example where De morgan's law can be applied.
(not A) AND...