The following t-SQL deletes rows from a table named "output_wal_ytm_detail" where its column calc_date contains values over 10 days old:
DELETE output_wal_ytm_detail
WHERE calc_date < DATEADD( dd , -10 , GETDATE() )
The following t-SQL deletes rows from a table named "output_wal_ytm_detail" where its column calc_date contains values over 10 days old:
DELETE output_wal_ytm_detail
WHERE calc_date < DATEADD( dd , -10 , GETDATE() )