create procedure xxx
as
declare @ct varchar(4)
declare @sql varchar(500)
set @ct = (select count(*) from b)
set @sql ='select top ' +@ct+ ' * from a
exec(@sql)
create procedure xxx
as
declare @ct varchar(4)
declare @sql varchar(500)
select @ct = (select count(*) from b)
set @sql ='select top ' +@ct+ ' * from a
exec(@sql)