What would be best way to show N number of column as per no of days in month

i want to show this kind of output

UserID  UserName 1  2  3 30

OR

UserID  UserName 1  2  3 31

user data saved in db select distinct UserID,Name from Userss Where IsActive=1 and order by UserID

and i want to just calculate no of days in month based on year and month name supplied by user.

one way i can do it. first i will create a temporary table and in loop add many columns to that table and later dump user data to specific column. i am not sure am i thinking in right direction. anyone can come up with suggestion or code sample to achieve it. thanks