sql语句中insert into 表中 select多个值后插入数据

insert into A (Date,FailCount,FailFirstCount,FailSecondCount,FailThirdCount,RecoveryCount)
select '2014-01-01 00:00:00'
,(select count(*) from [201311] where byAreaName =1)
,(select count(*) from [201311] where byAreaName =1 and FailLevel =1)
,(select count(*) from [201311] where byAreaName =1 and FailLevel =2)
,(select count(*) from [201311] where byAreaName =1 and FailLevel =3)
,(select count(*) from [201311] where byAreaName =1 and  IsRecovery=1)

select的多个值分别insert into A表中分别对应各个值