How to get two counts columns in result set table

select
(select COUNT(*) from HX_Issue where ProjectId=1 and ComponentId=13 and  CreatedOn between '2012/12/24' and '2013/01/30' and StatusId !=23) as OpenIssues
,
(select COUNT(*) from HX_Issue where ProjectId=1 and ComponentId=13 and  CreatedOn between '2012/12/24' and '2013/01/30' and StatusId =23) as closed

select 
distinct DATEPART(month, exq.CreatedOn)
(select COUNT(*) from HX_Issue inq where inq.ProjectId=1 and inq.ComponentId=13 and  DATEPART(month, inq.CreatedOn)=DATEPART(month, exq.CreatedOn) and inq.CreatedOn between '2012/12/24' and '2013/01/30' and StatusId !=23) as OpenIssues,
(select COUNT(*) from HX_Issue inq where inq.ProjectId=1 and inq.ComponentId=13 and  DATEPART(month, inq.CreatedOn)=DATEPART(month, exq.CreatedOn) inq.CreatedOn between '2012/12/24' and '2013/01/30' and StatusId =23) as ClosedIssues,
from HX_Issue exq
where ProjectId=1 and ComponentId=13 and exq.CreatedOn between '2012/12/24' and '2013/01/30'

select 
DATEPART(month, CreatedOn) as month,
COUNT(case when StatusId!=23 then 1 else null end) as OpenIssues,
COUNT(case when StatusId=23 then 1 else null end) as ClosedIssues
from HX_Issue where ProjectId=1 and ComponentId=13 
and CreatedOn between '2012/12/24' and '2013/01/30'
group by DATEPART(month, CreatedOn)

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Zoltán Zörgő
-- Create date: 2013.01.31
-- =============================================
ALTER PROCEDURE [dbo].[IssueReport] 
	@ProjectId int,
	@ComponentId int,
	@FromDate Date,
	@ToDate Date
AS
BEGIN
	SET NOCOUNT ON;
	with DateCte as
     (
         select cast(@FromDate as datetime) DateValue
         union all
         select DateValue + 1
         from    DateCte   
         where   DateValue + 1 <= @ToDate
     )
   select 
		DATEPART(year, DateValue) as year, 
		DATEPART(month, DateValue) as month,
		(select COUNT(*) from HX_Issue where ProjectId=@ProjectId and ComponentId=@ComponentId and DATEPART(month, CreatedOn)=DATEPART(month, DateValue) and DATEPART(year, CreatedOn)=DATEPART(year, DateValue) and StatusId !=23) as OpenIssues,
	    (select COUNT(*) from HX_Issue where ProjectId=@ProjectId and ComponentId=@ComponentId and DATEPART(month, CreatedOn)=DATEPART(month, DateValue) and DATEPART(year, CreatedOn)=DATEPART(year, DateValue) and StatusId =23) as ClosedIssues
   from  DateCte
   group by DATEPART(year, DateValue), DATEPART(month, DateValue)
   OPTION (MAXRECURSION 0)
END

EXEC    [dbo].[IssueReport]
        @ProjectId = 1,
        @ComponentId = 13,
        @FromDate = '2012.01.01',
        @ToDate = '2013.02.15'

GO