The solution I tried:

IF EXISTS

(Select 1 FROM Critical_Attributes

WHERE Table_Name = 'Network_Adapters'

AND Column_Name = 'IP_Subnet')

BEGIN

INSERT INTO Critical_History (Table_Name, Column_Name, Field_Data, Date_Archived)

SELECT 'Network_Adapters',...

Very good information. I have done this before but never quite so eloquently.

====================

"Awful tired now, Boss. Dog tired."

http://www.dwacon.com