TEMPDB..sysobjects!!!!

Cool, now go back to the firs tlink I gave you and reread it... we still the the ddl of the table, the problem code, the expected results and the...

Frank is working hard... he was responding on this site after his work.. whil I can do both at the same time.

That can't be good, can you restart the service (and the server if that doesn't work)?

Hey we found who Homer Simpson is .

Did you run sp_dropserver?

Did you restart the service/server?

Sure thing... just not gonna happen untill I transfer to NYC .

Check out which version is faster... that always change from one table to another... and in rarely is the fastest.

Declare @Names table (name varchar(25) not null primary key clustered)

Declare @Peeps table (name varchar(25) not null primary key clustered)

Insert into @Names (name) values ('remi')

Insert into @Names (name) values ('sushila')

Insert into...

Or even a search form... You just can't download 1.5 M records and show them... that's just not programming.

You must delete from test2 to insert in test3.

Please send the code you are using now so we can fix it.

Just because I rebeat you 2 more times in this thread .

Anyways I stopped bothering with how that recipient thing works. As far as...

And the select alone works??

Once you make it work you'll be ok.

What's the report about?

What statement do you use to delete the data?