To get distinct statements from audit(set)

 To get distinct statements from audit


SELECT TOP 100 text, query_plan
INTO TESTJuly14
FROM sys.dm_exec_cached_plans cp
       CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle)
       CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle)
WHERE objtype='Adhoc'



DECLARE @DML TABLE (DML VARCHAR(10))
INSERT INTO @DML (DML) VALUES
('SELECT'),('DELETE'),('UPDATE'),('INSERT')


SELECT DISTINCT text
  FROM TESTJuly14 t
    CROSS APPLY @DML d
 WHERE text LIKE d.DML+'%'