Re: remove duplicate items

Il giorno Thu 14 Feb 2019 10:57:31a, *Ammammata* ha inviato su comp.databases.mysql il messaggio
news:XnsA9F66F7DD5898ammammatatiscalineti_at_148.251.67.112. Vediamo cosa ha scritto:

Thanks to both replies, I will test them

I solved (before your replies) inserting another DISTINCT as below:

>
> Select distinct
> STUFF((Select DISTINCT ' / '+ cast(t1.docnum as varchar(100))
> from #tmp T1
>

Bye

-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
>>>>>  http://www.bb2002.it :)  <<<<<
........... [ al lavoro ] ...........