如何在sql server 2005中获取x和y之间的日期表

I just want a quick way (and preferably not using a while loop)of createing a table of every date between date @x and date @y so I can left outer join to some stats tables, some of which will have no records for certain days in between, allowing me to mark missing days with a 0I just want a quick way (and preferably not usi