I tried this. But I still get the same results.

This is what I made changes

if ((select max(ID) from table1)=(select max(ID) from table2)) exec xp_cmdshell `sqlcmd -E -S "DBNAME\INSTANCE1" -h-1 -Q ` (

echo executed commandshell

start "" "D:\firstpgm\bin\Debug\firstpgm.exe"

goto end

)

:end

echo...

When you say "you can attempt to move smaller amounts of data so that an index will be of assistance. " are you saying I should get select top 1000...

I only need to print Max date for each valid company ID.

For Company ID=1; 1003,1,2014-02-11

CompanyID=2; 2002,2,2014-02-13

No, finalTbl does not have any triggers.

What I mean by vague is that I do not have control over third party API result. All we know by experience and analyzing records is that if the JSON...

"not correct" - API returns vague result.

@SSChampion,

But how would I insert into employeeaddresses table? Can I have 2 table valued parameters as input to a procedure is my question? one to insert empaddr_verified using EMPTBL...

Yes, all records from tobeverified needs to be sent to an API for address validation. I want to insert 10,000 records into verified tables as efficiently as possible.

insert into empaddr_tobeverified('1','1 main st, salem,pa,USA','JOE STILTON');

insert into empaddr_tobeverified('2','200 Baker st, salem,pa,USA','JIMMY WU');

insert into empaddr_verified('1','1 main st, salem,pa,USA | 100 WHITE Terr, Acton,MA USA',1)

-- means that employee...

@SSChampion, By batches you mean maybe based on certain dates.

@SSChampion, many of these records have same dateinserted. so, we want one record per Unique ID, name, dateinserted

@SSChampion, I do have a clustered index on ID. Table was created by somebody & had not been maintained until it ran out of space. So, i am assigned to...

Thanks for the link to post the code properly & for the answer too.

I want to display name,address,date inserted but group by only ID.