He is my friend who ask the question in proper way his question is
he has a table in which there is dates and date is from 1 till 20
his problem is that he want to show a month all dates not 1 to 20
1 2 3 4 5 6 7 8 9 .............................................30 or (whatever 29 etc)
and show records of them if it has 1 to 20 date but show 1 to all and if it doesn't have any data in 21 to 30 show empty column but show 1 to last day of month
When questions are asked poorly, answers can't be wise either. I, for example, didn't understand what you are talking about. The first message contains a "so-called" example, but - as it is not formatted - I don't feel like deciphering what you meant to say. The same goes for your last message.
I *think* that some kind of a row generator is what you are looking for, but - can't tell for sure. If you want, check "missing data" discussions.
Or, rephrase your question, learn how to properly format it, explain what your input and output are/should be, and hope that someone will be able to answer.