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>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
View Trouble
- Thread starter JCC
- Start date
- Thread starter
- #2
You should send us your view's query.<br>I think it's a y2k problem. Have you stored the value in the column like mm/dd/yy or like mm/dd/yyyy? If it is mm/dd/yy format, all your year 2000 data could be stored like 19th century (i.e. year 1900). If your view query is using date comparison with mm/dd/yyyy format (like <col> BETWEEN '01/01/1997' AND '12/31/2001'), the values stored with mm/dd/00 don't meet the query criteria. You should review you view's query and create an expresion which can retrieve year 2000 values.<br><br>Good luck! <p>Eduard Stoleru<br><a href=mailto:e_stoleru@yahoo.com>e_stoleru@yahoo.com</a><br><a href= > </a><br>
- Status