I am working on a report where it requires pulling data from various sources, databases and data exported into excel sheets from different databases. The objective of the report is to create a single report with all the Providers (HPs) that have been terminated.
So what I have done is that I have exported all the data on a local server in the pubs database and I am using a TSQL query to return the report.
The same providers may exists in the various data sources so I have to make sure that I am only returning the data once...how ever the challenge is that, other than FirstName and LastName, there are no consistent IDs that we can use in all. For example,
not all of the records have the SSN, PhoneNumber, or other IDs that uniquly identify the record.
I have to create a report that returns the result set and identifiys the matching records and the source system the data is from..for example the output should display as such:
Below is the approach I I have taken to return the data and I wanted to know if there is a more efficient and better way of doing this:
DECLARE @matchingTerminated Table
View Complete Post