Hi GSquared

This will be run only once in the production.

ADDRTYPE [char(2)] field has only two records. 'ME' and 'MA'.

I am using all these indexes in my query. I just attached a portion of the code.

I validate RETCUST_CUSTADDR...

Attached a sample of my code

[font="Courier New"]-- 43. Validate English Name Address 1

-- 43.1 NAMADDR1 NULL or Blank

INSERT INTO CustomerReport

SELECT CUSNO

,43

,1

,NAMADDR1

FROM dbo.RETDCUST_CUSTADDR

WHERE (COALESCE(NAMADDR1,'')='') AND ADDRTYPE='ME'

-- 43.2 NAMADDR1 exceeds...

I am using all these index fields in a WHERE condition. I am using this table for a data conversion purposes. So, I need to search all these fields for...

I use following query to remove those records. Problem solved.

[font="Courier New"]DELETE FROM @TABLE

WHERE EmpID IN(SELECT MIN(EmpID) AS EmpID FROM @TABLE GROUP BY Category)[/font]

[font="Tahoma"]I want to remove the lowest value in each category[/font]

I found it. 🙂

The correct code is,

[font="Courier New"]pkg.Tasks("04: Transfer Data from ODS to DCSA").Properties("RowsComplete").Value[/font]