Lynn,

The posted solution seems to do the trick...thanks so much!

Hi Lynn,

If there are only 2 then it's just ignored. Three is the magic number! 🙂

Thanks for responding Lynn! Below is a small test case.

CREATE TABLE [dbo].[ActivityTable](

[CompanyId] [int] NULL,

[CompanyName] [varchar](20) NULL,

[ActivityDate] [date] NULL

) ON [PRIMARY]

GO

insert into ActivityTable values(1,'ABC','2014-08-01')

insert into ActivityTable values(1,'ABC','2014-08-03')

insert into ActivityTable values(1,'ABC','2014-08-10')

insert into...

I figured it out...never mind! 🙂