How To Compare Data Before Deletion

SET identity_insert dbo.table1 on

GO

insert into dbo.table1(
PrimaryKeyCol,Col1, Col2 .....)


select

PrimaryKeyCol,Col1, Col2......

from [Sever].Database.dbo.table1 as ClientColumn

where not exists(

select * from dbo.table1 as ServerColumn

where ServerColumn.PrimaryKeyCol = ClientColumn.PrimaryKeyCol

)

DELETE FROM [Server].Database.dbo.table1

where exists(

where ServerColumn.PrimaryKeyCol = ClientColumn.PrimaryKeyCol

)



SET identity_insert dbo.table1 off

GO


I can't complie this code.. anybody see where I went wrong??

Thanks for all your help.