Thanks. Almost what I need. Is it possible to compare the values? If the same value exists, I don't want it to count.

insert into #t1 values('11111','2022-01-10 13:37:06.000','P1','P2','P3','','','')
insert...

Thanks for the response. Unfortunately, I have no control over the data. It's a 3rd party database. This is how they designed it.

Your solution groups by vid and orddate.

What I...

• This reply was modified 3 years, 1 month ago by don075.

Thanks for the response. This works well. Much appreciated.

Great. Thanks for all the replies. Much appreciated.

Please see the attachment

• This reply was modified 3 years, 3 months ago by don075.