Heya,<br><br>I'm pretty new to SQL server and I have a problem with a view I created. I'm using NT 4.0 sp6 and SQLServer 7.0 sp1. The source table contains about 1,500,000 rows and the records are dated from 9/30/97 to 4/28/00. When I open the view it contains records dated from 9/30/97 - 9/18/99 and then the records start back at 9/30/97 and continue as such. Any clues as to why this is happening? I'm using this view to make a cube and it's giving me fits.<br><br>thanks in advance. <p>Jackson C. Cooper<br><a href=mailto:jacksonc@orrcorp.com>jacksonc@orrcorp.com</a><br><a href= > </a><br>