create proc [dbo].[proc_Delete]

@TableName varchar(50),

@Id varchar(5000)

as

begin

declare @strSql varchar(5000)

declare @sql varchar(4000)

set @sql='select col='''+ replace(@Id,',',''' union all select ''')+''''

if OBJECT_ID('tempdb..#DelID') is not null

drop table #DelID

create table #DelID(ID VARCHAR(36))

insert into #DelID exec(@sql)

set @strSql = 'delete from '+@TableName+' where RId in ( select ID from #DelID)'

exec(@strSql)

end

GO