Jason-299789 (1/7/2013)
You can solve this with a Calendar Table, once you have a Calendar table in place its simple to then run a Cross tab to get the values, in place..
Do you have any link for this ? for Calendar table
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)