You have some values that have leading zeros.  Must the leading zeros be preserved?  If so, then not all of the columns are actually INTs as you said.  Let...

Actually, for this one, I just looked at the query plans.  The other code is doing...

• This reply was modified 5 years, 2 months ago by ScottPletcher.

This has less overhead, which may or not be a concern to you for this task, but I thought I'd post it just in case.

;WITH cte_find_last_2_dashes AS...

CREATE TABLE #3NF_ATCCOLLECTION 
    (
    ATC_KEY varchar(7) NOT NULL
    );
INSERT INTO #3NF_ATCCOLLECTION VALUES
    ('A10'), ('A10Q'),...

To answer the question, you could instead change the criteria you cited to...

AND log_reuse_wait_desc <> Nothing'

Like I said in the comment in the code I posted,...

we are currently doing a 1 hour tran log backup for a system, I'd like to push that up to 1 minute. Is there a performance hit to...

The big disadvantage I see for dynamic-only code is that you can't analyze them at all, whereas with views you can.

For example, "How many Configs use 'Integer3'?" or "Do we...

Has to be calculated in runtime so i cant just place them into a table and use identity column

Not following you there.  Why can't you look up the "meta-key" from...

The ORDER BY is useless (rather than "absolutely essential").  ORDER BY doesn't control the order of physical INSERTs into a table, only the assignment of identity values.  I've...

Actually I intended by code to be run anytime the Config for a given AttributeType was modified.  After the initial build for every AttributeType in Config, I expected it typically...

@pamkagel ,Do your insert in the following form...

 INSERT INTO dbo.yourtablename WITH (TABLOCK)
        (full column list here)
 SELECT full...

Btw, how then do you exec the code the function created?  Wouldn't you some type of loop / cursor to do that anyway?

I admit that I prefer using a cursor here to make it easier to adjust and customize the code.  As the OP stated, there will be special requirements for some...

No sir... There are a couple of "standards".  The "standard"...

Now, there's an interview question...