随笔-68  评论-89  文章-0 

多选框查询显示

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)
posted on 2007-05-31 13:34 噢耶游戏 阅读(...) 评论(...) 编辑 收藏