I tried this out today. The procedure worked until it got to the line "having count(*) > 1". When that line is inserted, I do not receive any results. I...

Thank you very much. I will try this out as soon as possible and let you know how it works. Your assistance is very much appreciated.

This is my SP for deleting rows more than x days old:

CREATE PROCEDURE [dbo].[PurgeWinAudit]

@DaysOld Int

AS

delete FROM dbo.winaudi2

where datediff(dd,DateTimeDB,getdate())>@DaysOld

GO

This is my view statement:

SELECT ItemValue1, DateTimeDB, AuditID

FROM...