I agree, put the info in a temp table. Then use a "GROUP BY" select statement to figure out how has more than one SSN (the same).

DECLARE curData CURSOR...

it depends on the "recovery model" you picked. if you didn't "pick one", then you probably defaulted to "simply recovery".. which is basically, BACKING UP and .. (if something...

Heres a function I wrote:

if exists (select * from sysobjects where id = object_id('dbo.fnc_short_date') and xtype = 'FN')

drop function dbo.fnc_short_date

GO

CREATE FUNCTION fnc_short_date (@datInputDate datetime, @separator char(1))

RETURNS

varchar(128)

AS

BEGIN

RETURN

CONVERT(Nvarchar(20), datepart(mm,@datInputDate))

+ @separator

+...

I found that 10-12 was it. MSDE is basically a "sql server lite" version...(my phrase, not microsoft's). Its a stripped down version.

You need to get Access2000 and install...