Merge\Combine two datatables
- by madlan
I'm trying to merge\combine two datatables.
I've looked at various examples and answers but they seem to create duplicate rows or require indexes (merge on datatable etc)
I can't do this via SQL as one source is from a linked Oracle server accessed via MSSQL and the other from a different MSSQL Server that does not have linked access.
The data is…