Another perfect situation for a tally table. You can create an in-line table using CROSS JOINs or create a physical tally table and use that. Unfortunately I can't...

I used CASE rather than ORs ;-).

SET NOCOUNT ON

--Temp table DROP/CREATE, in alpha order--------------------------------------------------------------------------------

IF OBJECT_ID('tempdb.dbo.#CheckTables') IS NOT NULL DROP TABLE #CheckTables

IF OBJECT_ID('tempdb.dbo.#Results') IS NOT NULL DROP TABLE #Results

CREATE TABLE #CheckTables...

If the code ran in just 8 minutes, and you like it and results, it's logical for you to leave it as is.

I agree. You'd expect the specifically-chosen (?) "featured script" to be something at least moderately good/useful, but most often they are not.

As for this code, I would suggest simply:

SELECT...

Alan.B (4/17/2015)

---

Nope, not that I am aware of. Not without using a sp_cmdshell or other non-tsql scripting tool

What's wrong with this?

SELECT

DbName = db.name,

FileType =...

There could also be some type of locking, and thus blocking, on the underlying system tables. I've seen this happen when, for example, people do a "SELECT ... INTO...

Since you're trying to do a keyed lookup on the CL table, the conversion should be other way around to allow SQL to do a seek on all three key...

I see a couple of other issues, besides formatting, with your code.

1) Step 0 is a summary for the entire job, including duration. So if you add step 0...

RonKyle (4/20/2015) What does this mean? The default is 0 (100%)....

RonKyle (4/20/2015)

If your choice of a clustered index...

Doesn't have to be an iTVF, you can still use dynamic SQL, just process all columns in a given table in one statement, not multiple.

dwain.c (4/19/2015)

---

ScottPletcher (4/17/2015)

---

The on-going maintenance is higher for an INSTEAD OF trigger, since every column addition or deletion, and some column changes, all requires changes the trigger, which is not...

Cursoring through the tables is fine, but you should process all columns in a single table in one pass (scan), not a separate pass for each column.

I don't understand how this code can work.

Your subqueries to tt1 / t2 don't contain any column named "Id_1" yet you reference that column when you join to t2: I...

First, I don't see that code as turning on any setting. It sets a local variable value, that's it. You happened to name that local variable "[@]IMPLICIT_TRANSACTIONS", but...