I was a flight attendant for almost 27 years before changing to a Database Developer! Ten years later, I LOVE going to work every day and still sometimes laugh...

Thank you, I learned something today! Fortunately, I don't have to write dynamic sql anymore 🙂

I believe this is what you need - dynamic SQL syntax is tricky. Each line needs a statement of

SET @sql = @sql + ':

...