Jeff Moden (4/5/2010)

---

This is such a terrible idea that I have to ask. ...

Then i would suggest you to create a unique column and then proceed. A system generated IDENTITY column should be fine unless it breaks your existing code or procedures.

One more idea would be...

🙂 Glad i could help you. Happy coding.

Inside an INSERT trigger, you will not have any data in the deleted table. Only the inserted will have data.

Why are you preferring delete + insert method over the update...

From your post it seems PostID is the primary key in table1 and foreign key in table2. If it is so you should join on PostID column.

Your code should look...

This seems to a basic INNER JOIN query. Look for INNER JOIN in Google or Books Online. Try some code on your own and if you have any further difficulties,...

You can do this by a simple join

UPDATET2

SETBatchid = T1.Batchid

FROMtable2 T2

INNER JOIN table1 T1

ON T2.document = T1.batchname

Go through the below link where a similar issue was discussed

http://www.sqlservercentral.com/Forums/Topic890414-338-1.aspx

vidya_pande (3/29/2010)

---

This trigger is fine. It should send the mail for each insert statement. In SQL Server trigger is fired at statement level.

If number of rows afftected(in update or...

I meant all the records that are inserted. You can have a statement that inserts 10 records or deletes 10 records at one go. Even in that case you would...

From the above code you would get either one mail or no mail at all. You will have to use a cursor or a While loop to loop through all...

You cannot use an IDENTITY column for this. You will have to use a Computed Column.

DECLARE @tblTable TABLE

(

Col1 TINYINT IDENTITY(1,1) NOT NULL,

Col2...

It would help if you can give us some sample data and the table structure. It would be difficult to help you with the given information.

From whatever i understood, I...

Thats what i was looking for. But sadly i don't have SQL Server 2008. I can use your other methods till then. Thanks once again Paul.