Home Forums SQL Server 2005 Administering t-SQL query (convert to 2005) RE: t-SQL query (convert to 2005)

  • August 14, 2009 at 7:18 am

    #1039306

    it's your order by, your are referencing an alias.

    change it to "ORDER BY 5 DESC" instead of "ORDER BY NOTA.CODLIQ DESC"