@MMartin1 - Most of the flamers selectively read the article(s).  In this case, they don't understand that you were demonstrating best practices of defense against worst practices of database design.

Good...

Dang - things weren't so complicated for us ground-pounders.

Wow.  One can do nearly everything except build windows (forms)...

Thank you, @jonfrisbee, for sharing.  Based on your article, I whipped up this quickie:

declare @SepRepl char(1)=''
declare @ColNums int=3
declare @ArgValList varchar(max)='
1DISABLE_DEF_CNST_CHK0
2IMPLICIT_TRANSACTIONS0
4CURSOR_CLOSE_ON_COMMIT0
8ANSI_WARNINGS0
16ANSI_PADDING0
32ANSI_NULLS0
64ARITHABORT0
128ARITHIGNORE0
256QUOTED_IDENTIFIER0
512NOCOUNT0
1024ANSI_NULL_DFLT_ON0
2048ANSI_NULL_DFLT_OFF0
4096CONCAT_NULL_YIELDS_NULL0
8192NUMERIC_ROUNDABORT0
16384XACT_ABORT0
'
declare @RowDelim char(2)=char(13)+char(10)
,@ColDelim char(1)=char(9)
,@Sep char(1)=','
set @ArgValList=replace(@ArgValList,@Sep,@SepRepl)
set @ArgValList=replace(@Sep+replace(replace(replace(replace(@ArgValList,@ColDelim,@Sep),@RowDelim,@Sep),char(9),''),@Sep+@Sep,@Sep)+@Sep,@Sep+@Sep,@Sep)
declare @opts...

• This reply was modified 5 years, 10 months ago by John N Hick.

Thanks, aveek22.

I, too, use NOT EXISTS but I wonder if by using a co-related subquery  we are doing a performance no-no...

Although I disagree with your solution, I appreciate that you took the time and spent the effort to write this article. 
I do agree with John Rees in how...

I am sorry that I didn't see this last year - great article!

Also, my apologies, Jason!  The first line of my previous was supposed to resemble, "Great article, I gave you 5 orbs!"  Again, sorry.

I once wrote a Powershell script to release multiple files into several environments and log messages and errors.  I requires creating some text files with run-time arguments (so you don't...

Thanks for the article!  I've never run into the situation, but it is very good to know.

Thank you for sharing this.  I would personally add one more step to this extensive list:  take the db offline for a few months (13 ?) and wait for the...

OK, I see it now, thanks!