I've got an issue with a file being submitted to the FL department of revenue. The file is for quarterly SUTA reporting and is being generated by an accounting package. The problem is, they are telling me it contains duplicate employees. They say they are unable to tell be which ones are duplicated. The file has over six hundred employees in their funky XML format. They suggested I open the file in note pad to find the duplicates. Is there a way for me to move the contents of this file to a table to make sure I find all the duplicates? Each record in the file is 1024 characters long and there doesn't appear to be a carriage return at the end of each line. The example below is for one employee.

<Employee><SSN>000000021</SSN><Employee><FirstName>Foster</FirstName><MiddleName></MiddleName><LastName>Grant</LastName><Suffix></Suffix></Employee><TotalWages>0.00</TotalWages><TaxableWages>0.00</TaxableWages><OutOfStateWages><TotalWages>0.00</TotalWages><TaxableWages>0.00</TaxableWages><TaxState>XX</TaxState></OutOfStateWages></Employee>

TIA
Jeff