[dba-SQLServer] Append only records where some fields not in the table already

Hi John

You are welcome. 
This is really too easy if you use the SQL query GUI of Access.

/gustav


>>> jwcolby at colbyconsulting.com 03-09-2009 17:26 >>>
Gustav,

You have a mind like a steel trap.  I on the other hand have a mind like an rusted old iron trap, 
set back in the early 1800s and long since buried under 2 feet of leaves and mud.

Unfortunately I cannot figure out how to do this in SQL Server.  But I did get a solution based on 
Paul's suggestion.

Thanks for the help.

John W. Colby
www.ColbyConsulting.com 


Gustav Brock wrote:
> Hi John (I have posted this in 2000, 2001, and 2006 - even as a reply to a posting of yours)
> 
> This tip from Smart Access is one of my favourites: