Hi, you can add a Distinct on the count(SSN). Here is the code:

SELECT P.FirstName,

p.LastName,

p.SSN

FROM Person p

INNER JOIN (SELECT ...

Well here is the plan, and I will post the query too, just thought it was a really cool plan to debug... 😉

/* FULL UPD */

SELECT 'ExtractTagH',

'BatchNbrH',

...

Here, see if that helps!

USE TEMPDB

GO

CREATE TABLE Person (

FirstName NVARCHAR(30),

LastName NVARCHAR(30),

SSN NVARCHAR(15))

INSERT INTO Person

SELECT 'Donald', 'Duck', 'SSN-001'

UNION...

Finally got it to work! There was an error with my login, it was not in the right order, needed to put 'Sa' as the third paremeter, not the fourth!!!

Here...

Hi Jeff, thanks for your answer.

I still get the problem, I used the procedure to see if the server had access and it gave me this result:

subdirectory ...

Jeff Moden (8/16/2008)

---

Heh... that's known as a "Headerless Ragged Right" file and they're a bugger to import correctly. BCP and BULK insert require that all the rows have the...