Posted by david.buckingham@gmail.com on 04/06/06 17:22

As a short-term fix, I have replaced this query with a cursor.

The reference to the sqljunkies blog entries doesn't help. There is no
difference between what I'm accomplishing with the current query,
versus moving that same query into a scalar function.

Erland: I'm confused regarding the article that you posted. I am not
calling any functions in the select list, or the order by clause. I
don't understand "The correct behavior for an aggregate concatenation
query is undefined." I am successfully using similar queries in
multiple solutions, this is the first time that I have experienced this
problem. Again, I've only moved the database to a new server and then
this problem began.

Thanks All!
David

[Back to original message]