1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| WITH CTE
AS (SELECT TOP (10) P.*
FROM trace P
INNER JOIN Purge_traces J ON p.id = J.id)
DELETE D
FROM trace D
WHERE id IN
(
SELECT id
FROM cte
);
PRINT 'Number of rows deleted on trace is ' + CAST(@@ROWCOUNT AS CHAR(3));
----================================================================================================================================
--Insert Log Table Purge_trace
--================================================================================================================================
INSERT INTO Purge_trace
(tablename,
deletiontime,
rows_affected
)
VALUES
('trace',
GETDATE(),
@@ROWCOUNT
); |
