HI I Have to do a query that will produce an unmatched listing.
On server A which is our vendor's server, which is a SQL Server 2005, we have a transactions table. We want to see for the past 2 days only:
which InvoiceNumber(int 20 null) is NOT on our Document server
which is mysql the column there is:
Docnumber Varchar 64 Binary.
I am not sure how to get to the servers. I am used to getting to a different server in c# using 'connection strings' but how to do this in query?