Test successfully!
declare @num int;
select @num=count(*) from budget where fk_project_id=62;
declare @topstr nVARCHAR(256);
set @topstr='select top'+str(@num) +' * from budget';
execute sp_executesql @topstr ;
Test successfully!
declare @num int;
select @num=count(*) from budget where fk_project_id=62;
declare @topstr nVARCHAR(256);
set @topstr='select top'+str(@num) +' * from budget';
execute sp_executesql @topstr ;