SQL Query to delete online marketing Activity from database
You can first look for ID with the help of below query:
SELECT [ActivityID]
,[ActivityCreated]
FROM [RotoruaNZ-Live].[dbo].[OM_Activity]
WHERE
[ActivityCreated] > '2015-01-13 15:29:07.000'
ORDER BY ActivityCreated ASC
DELETE FROM [dbo].[OM_Search]
WHERE SearchActivityID < = '2533036'
DELETE FROM [dbo].[OM_PageVisit]
WHERE PageVisitActivityID < '2533036'
DELETE FROM [dbo].[OM_Activity]
WHERE ActivityID < '2533036'