Good question indeed. I should have spotted that the aggregates will fail due to untyped NULL. If the null value in the last statement were typed, it would work just fine.
Ole Kristian Velstadbråten Bangås -
Virinco -
Facebook -
TwitterConcatenating Row Values in Transact-SQL[/url]