Fast.Eddie (12/7/2016)

---

Not possible, there's a whole change request which takes ages and a lot of the requests we stick in are rejected because it's not 'business critical'. The company that runs the database took 2 weeks just to add 1 derived column into a table.

If it greatly effects performance doing it as a temp table then I would prefer to avoid this option.

Is there another solution for my query?

Thanks