• mukeshkane (9/10/2010)


    still getting the same error message

    Could you copy and paste the exact T-SQL code you are using? There must be something wrong there. I can run the code on my SQL Server 2005 test server, and I get the two rows returned.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/