how to add missing dates between two dates in sql server? I would like to know if there is any way to fill in missing dates through a query.