How to create days Dynamically for a month with the conditions in sql

See more:

SQL

SQL-Server

SQL-Server-2008R2

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

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