I'm not sure if this is the answer the OP is looking for, but a derived table may be what is being referred to as "Normal SQL"

In that case,

with...

While there's nothing wrong with the above approaches functionally, you're not doing any favors to anyone who has to read this code after you. If this was me, I would...

Don't forget to right-click the file and take ownership of it (as the account running SQL Server services).

Last time I encountered what you encountered, an outside developer had created the...

I've lost my laptop to burglars, but was already practicing what's being discussed here.

All files backed up somewhere other than the laptop.

All important and sensitive files not retaining copies on...

For me, it's not always about risk with these decisions. We use Stored Procedures almost exclusively and I like the fact that we have a pretty thorough documentation of our...