Issue converting the following query to text.

It shouldn't be that complicated :) there has to be an easier way around it,

Actually it has, because this is nothing you would normally do in the engine, but this belongs in the frontend. SQL Server is not a general-purpose environment.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se