Now tell me you don't own a gun, please!!!!!!!!

It's possible, just don't expect to have it happen overnight. Just like my pool carrer, it took me 4 years just ot win 1 tournament, but everything's coming together...

Test3 must be created before you try to insert into it. This is a permanent audit table... Also they usually have a default field (auditDate default GetDate()).

http://vyaskn.tripod.com/code.htm#inserts

Download the sp, install it and follow there instructions to see hwo to generate the insert statements.

Now THAT would be a trick question .

My solution is the right way to go... select into should be avoided at all costs in production.

No it's not a lost cause... I can be hung up somewhere else and that gives you enough time.  but this one was close (assumine you meant to time insert...

http://www.insidesql.de/

Last thing to add to find a temp table :

if Object_id(tempdb..#tempTable)>0

--it exists

else

--it's been destroyed somehow

CREATE TRIGGER tr_AuditTableName_D ON [dbo].[Test] 

DELETE

AS

SET NOCOUNT ON

Insert into dbo.TableAudit (col1, col2) Select Col1, Col2 from Deleted

GO

I can't make out what you want either.

Looks like you application is doing a lot of stuff but it's not working for all the data.  Is it possible that you...

Check out exists and left join in the books online.

Exactly where I was going at .

Is that a request or a fact .

Can you show me the code you are using?