I want to detect the missing recordings in a table of destination by means of a select minus or where not in but tables have no same structure and I shall wish to insert what misses:
insert into dbtarget.schematarget.table
select * ,
From [ serversource ] .dbsource.sys.schemas
Objectpropertyex (object_id (' 01A.ACES ') where schema_id = ', SchemaId ')
) as folder from [serversource] .dbsource.01A.ACES
select * from dbtarget.schematarget.table where [ folder ] = ' 01A '
How can do this, do you have an example?