insert into result (a,b,c)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)
(select
(select count(*) from data1) as a,
(select count(*) from data2) as b,
(select count(*) from data3) as c)
declare @b intselect @a=count(*) from data1
select @b=count(*) from data2insert into result(a,b) values(@a,@b)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)