Hi Greg,

The instance on which it is failing has the version: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft...

Hi,

thanks for the prompt reply but no good..I ran the query after adding the brackets but still got the same error..while the query is running fine on another server of...

Hi,

I ran the script and it was giving desired results but in some of the servres it threw the below error:

Msg 207, Level 16, State 1, Line 89

Invalid column name...