SELECT (select count(fecha_rec_ped) from reg_pedidos
where fecha_rec_ped>="'+Year1.Text+-01-01'" and
fecha_rec_ped<="'+Year1.Text+-01-31'") as enero, (select count(fecha_rec_ped) from reg_pedidos where fecha_rec_ped>="'+Year1.Text+-02-01'" and fecha_rec_ped<="'+Year1.Text+-02-29'") as febrero from reg_pedidos