I have made it a habit to include a check on compilation errors in my script.

Otherwise you may end up testing an old version of your program

CREATE PROC usp_getPlanes AS

SELECT...

In my case it was just that i had to declare the profile as "public" in SSMS.

in my event is was just, that the profile had to be declared "public" in SSMS / Management / Database Mail.

Think the cause for terrible performance is, strictly speaking, not RBAR but allocating a new string for each turn, because with integers it's blazing fast. Try yourself:

drop table test_table

;

with a...

Using select for XML to concatenate result strings is a fine idea I did not have.

Thanks for that!

The rest - I do not appreciate that much

if you want distinct, ordered,...