declare @num int
declare @num1 int
declare @str nvarchar(100)select @num1=(count(id)/4+count(id)%4), @num=count(id)/4
from younth_trade
set @str=' select top ' +cast(@num as char(2))+' tradefullname as name,id from younth_trade where id not in( select top 10 id from younth_trade order by id asc) order by id asc'
exec(@str)
declare @num1 int
declare @str nvarchar(100)select @num1=(count(id)/4+count(id)%4), @num=count(id)/4
from younth_trade
set @str=' select top ' +cast(@num as char(2))+' tradefullname as name,id from younth_trade where id not in( select top 10 id from younth_trade order by id asc) order by id asc'
exec(@str)
---
declare @str nvarchar(1000)