alter proc sp_getChecklistBox
@str varchar(50)
as
declare @sql varchar(4000)
set @sql='declare @tb table(id int,usid int)
insert into @tb select id,usid from TOp_TestReport where usid in(
'+@str+')
select * from Top_TestReport where id in(select max(id) from @tb group by usid)'
exec(@sql)
转载于:https://www.cnblogs.com/yintian2/archive/2007/05/31/766319.html