Hi Jeff, I was able to update the working table, data smear and NULLing with the fields necessary to populate the information of the original record, on the repeats. ...

Hi Jeff,

You are correct, The channel, org, date, agent and LOB are all supposed to be that of the FirstIR. Outside of that, this is perfect. I'm...

Requested format below. I'm new to this, thanks for the lesson!

IF OBJECT_ID('TempDB..#CRMIRTest','U') IS NOT NULL

DROP TABLE #CRMIRTest

CREATE TABLE [#CRMIRTest] (

[IRNumber] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL Primary Key,

[IRDate] [datetime]...

Thanks for the lesson, I'm new here.

IF OBJECT_ID('TempDB..#CRMIRTest','U') IS NOT NULL

DROP TABLE #CRMIRTest

CREATE TABLE [#CRMIRTest] (

[IRNumber] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL Primary Key,

[IRDate] [datetime] NULL ,

[Email] [varchar]...

Sorry about that, I provided the results instead of everything. Iv'e added the four missing fields on the attached.

Glad you insisted!

Attached is the structure and sample data. I have indexes on IRnumber(primary key), irdate, email, Statusprofile, RC, First IR and Invalid.

I have a process that...

Lucky me, the job just completed after 41:22:03. Running it on the daily updates from this point on will be painless. Hopefully I will never have to do...

Yes, It is SQL 2000 Server.