The SQL script to remove fake test items in NerdDinner database based on the keyword "test" and the date difference in future.

Nerd Dinner Fake Item Removal Script

DECLARE @CurrentDate datetime
SET @CurrentDate = getutcdate()

DECLARE @Days int
SET @Days = 180

DELETE [NerdDinner].[dbo].[RSVP]
WHERE [DinnerID] in 
(SELECT [DinnerID] 
 FROM [NerdDinner].[dbo].[Dinners]
 WHERE 
 [Title] LIKE '%test%'
 OR [Description] LIKE '%test%'
 OR (DATEDIFF(DAY, @CurrentDate, [EventDate]) >= @Days)
 )

DELETE [NerdDinner].[dbo].[Dinners]
WHERE 
 [Title] LIKE '%test%'
 OR [Description] LIKE '%test%'
 OR (DATEDIFF(DAY, @CurrentDate, [EventDate]) >= @Days)