这个怎么样？

在SQL Server中生成日期表 [ ^ ]

CREATE TABLE employee_active_on_proj
(
    EmpName varchar(50),
    ProjectName varchar(50),
    startofproject datetime,
    EndOfProject datetime
);

And here is one row of data

insert into employee_active_on_proj values('JOhn','Projet 1','03/04/2015','14/04/2015')

insert into employee_active_on_proj values('JOhn','Projet 2','16/04/2015','24/04/2015')

My output should be based on the inputs Month and year using stored procedure



=======================================================================
Empname 01/04/2015 .. 03/04/2015 14/04/2014 .... 31/04/2015

=======================================================================
JOhn N/A ACTIVE Project ends

========================================================================

How about this?
Generate Date Table in SQL Server[^]