gjshah7254
8/27/2014 - 9:22 PM

SQL Query to delete online marketing Activity from database

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'