Home Forums SQL Server 2008 T-SQL (SS2K8) Deprecated]Function call can be extracted from the WHERE clause to avoid unnecessary table scan. RE: Deprecated]Function call can be extracted from the WHERE clause to avoid unnecessary table scan.

  • January 16, 2014 at 10:31 am

    #1680764

    Lowell (1/16/2014)

    dateadd is not deprecated.

    I run it through ubitsoft's T-SQL Analyzer and I get the following:

    SA0028 : [Deprecated]Function call can be extracted from the WHERE clause to avoid unnecessary table scan.

    I'm not sure why I got that error.

    Thanks.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/