I have the same columns all the time...

But there could be multiple instances running at the same time..so if it were a premenant table, and two added their data at...

I didn't know if I could post this much data but here we go:

CREATE PROCEDURE spBuildSendList_New

@intCompID int,

@intTotalAmt int

AS

declare @strTableName varchar(10)

declare @str_sql varchar(100)

select @strTableName = '_' + convert(nvarchar,@intCompID )

select @str_sql =...

Thats half of it.....I know how to update it like that, but I want to return the emails that I just updated.

Any suggestions?

Yes...I did do something like that...

With a Full Outer Join...

Is that the same as a UNION?

Thanks.

well I don't do that..because there are multiple records with the same accountno, that have different Rectype...

So I want all the accountno's that don't have a rectype of 'E'...does that...