drop table #incoming
CREATE TABLE #incoming
([id] [bigint] IDENTITY(1,1) NOT NULL,
[tablename] nvarchar(50),
[action] [int] NULL,
[rowid] [bigint])

INSERT #incoming (tablename,action,rowid) VALUES('#test',0,1111) 
INSERT #incoming (tablename,action,rowid) VALUES('#test',0,1211) 
INSERT #incoming (tablename,action,rowid) VALUES('#test',0,1311) 
INSERT #incoming (tablename,action,rowid) VALUES('#test',1,1111) 

drop table #test
create table #test
([tid] [bigint],
[data1] nvarchar(50),
[data2] nvarchar(50))
INSERT #test (tid,data1,data2) VALUES(1111,'foo','foo')
INSERT #test (tid,data1,data2) VALUES(1211,'foo','foo')
INSERT #test (tid,data1,data2) VALUES(1311,'foo','foo')
INSERT #test (tid,data1,data2) VALUES(1111,'foo','foo')

SELECT 'DELETE FROM ' +  tablename + ' where tid =' + convert(char,rowid) from #incoming where action = 0

SELECT * from #test

declare @q varchar(max)
SELECT @q = ISNULL(@q, '') + 'DELETE FROM ' +  tablename + ' where tid =' + convert(char,rowid) + '; ' from #incoming where action = 0
exec(@q)