Home Forums SQL Server 2008 SQL Server Newbies View not working since moving database from SQL 2000 to SQL 2008 RE: View not working since moving database from SQL 2000 to SQL 2008
Ant-Green
SSC Guru
Points: 113488
More actions
January 11, 2013 at 2:37 am
#1576136
That is a funny one, as the convert is the same in the select and the where, so both should fail.
Would it be possible to post the DDL (CREATE TABLE script) form VP_EMPLOYEE and also some dummy data, to see if I can repro the error.