Brian Seib (6/10/2013)
Very strange - so I am was looking at one of the servers that this is running on and failing - and after looking through the history is turns out that somedays it works and other days it does not. So that pretty much takes any syntax issues out of the running. So this apparently is requesting information that is hanging some days?. I do not fully understand what the query is doing step by step, but it apparenly relies on the information on the database as it i works one hay and not the other, without my naking any changes to the database. Any ideas?
I suggest you to do an error handling (Just insert an error into another table) and find out what it's.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/