Thanks. I am now trying this with BULK INSERT and getting some different errors.

This is pipe delimited file with 14 columns and there is a LF at the end of...

Thanks. I'll head there.

Thanks. Where can I actually find the function?

Thanks. Putting the gloves on and cleaning now

No identity column. There is a FY and Month which looks like when a record was added to the larger dataset. But even as I eyeball that I see duplicate...

Oh... I haven't yet.

So now I need to look at that query and try to get the same information out. Because each SSN does have date records with different...

Thanks SSC - that was the problem. The file is cumulative so there are duplicate rows where every field is the same.

Sorry to drag everybody down with this.

Select

Main.* FROM dbo.empdata Main

INNER

JOIN (SELECT

Select

Main.* FROM dbo.empdata Main

INNER