gistfile1.txt

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[bd_purge_audit]
AS   
DECLARE @SQL varchar(max)=''

select @SQL = @SQL + '
SET NOCOUNT ON;
 
DECLARE @r INT;
 
SET @r = 1;
 
WHILE @r > 0
BEGIN
  BEGIN TRANSACTION;
 
  DELETE TOP (100000)
    dbo.' + table_name + '
    WHERE SyncFlag = ''true'';
 
  SET @r = @@ROWCOUNT;
 
  COMMIT TRANSACTION;
END;'
from INFORMATION_SCHEMA.TABLES 
where table_name like 'bdtriggeraudit%'

select @sql
EXEC (@SQL)
GO