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

  • Hi opc.three

    Perfect that worked, I just had to modify it slightly to change the 722 to @SearchNo which was a parameter.

    Cheers

    Douglas Bell