How to create days as columns dynamically with the condition in sql?

See more:

SQL-Server-2008R2

i need to create days dynamically for a month with the inputs month and year.

i am having the table project which saves project start date and end date

related to the employee,the employee can be worked in many projects.

The scenario which i have to find is as below

if my inputs are year=2015 and month=04

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

Empname 01 02 03 --- 31
================================================
emp1 Active project end

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


As like above i have to find whether the employee is active related to the

particular day..how to find ?