>Hi Naomi,
>
>Thanks for your reply. Initial research into the link is inconclusive as the various methods do not return the desired result regarding the non-repeating of duplicate CommentId's.
>
>Vince

Hi Vince,

In your first stage simply select non duplicate records, e.g.

;with cte_NoDups as (select Date, Comment from myTable group by Date, Comment)