Disregard

Perhaps "first" means the order in which the data was inserted into the table. It's like "First come, first served". This may not be the perfect SQL definition...

DECLARE @TABLE1 as TABLE (ROWSEQ INT IDENTITY, ID INT, SUBID INT, COMPLETE INT, LOCATION CHAR(20))

INSERT INTO @TABLE1

SELECT 2000, 0, 0, 'GEORGIA' UNION ALL

SELECT 2000, 0, 0, 'TEXAS' UNION ALL...

UPDATE MyTable set MyField = 'MyField was NULL' where MyField IS NULL

UPDATE MyTable set MyField = 'MyField was not NULL' where MyField IS NOT NULL

I don't claim to be an expert in either SQL or Excel but I tested the method shown above with the original data values given and that method does not...

WayneS (10/23/2010)

gmrose (10/23/2010)

Thank you (and all of the others) for your...

Thank you (and all of the others) for your suggestions. ...

Thank you again to Lutz and Wayne. I updated my script per Lutz' suggestions to use table #tmpChecks instead of table variable @tmpChecks. I made some minor adjustments...

This table currently has...

After I finish reading the article, I will need to build a new statement using its suggestions. The one that I built based on Lutz's solution has been running...

Thank you both for your help, Craig for the interesting article which I have started reading, and Lutz for the solution I needed.

gmrose