declare  @nvarchar1 nvarchar(4000), @nvarchar2 nvarchar(4000), @nvarchar3 nvfrchar(4000)...

exec (@nvarchar1 + @nvarchar2 + @nvarchar3...)

declare @interval table(f int, t int)
insert into @interval values(1,3)
insert into @interval values(4,8)
insert into @interval values(9,9999)

;with CTE
as
(
select object_id,count(*) as cnt
from	sys.columns
group by object_id
)
select i.f,i.t,count(*)
from	cte c inner join @interval i on c.cnt between i.f and i.t
group by i.f,i.t
order by 1

f           t           
----------- ----------- -----------
1           3           66
4           8           518
9           9999        1305

Сотрудник 01.07   02.07   03.07
Коля         5         9        4
Вася         8         7        9
Рома         9         5        7