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表中分别对应各个值