We would like to help, but please help us first to clear understand your question and get us going. Here is an article about how to do it on this...

That is how you should present this sort of question:

I have a Table as per:

create table #tbl_Duplicates

(pk_ResId int not null,

i_Number int,

ReservationId int)

-- sample data

insert #tbl_Duplicates select...

Could you please follow directions described in "The One":

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Again, don't do it in a trigger.

Do you have to report update which happen via some...

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to call xp_sendmail from a trigger...

Lisa Slater Nicholls (3/7/2012)

---

And sometimes they are just misunderstood.

[..]

a) Check if is feasible to drop...

just an idea:

select *, (row_number() over (order by [object_id],[column_id]) - 1) /99 as FileNo

from sys.columns

As you can see, data in the table will be given incrementing FileNo for the froup...

You can check if your database ever was backed-up:

SELECT Database_Name,

CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup

FROM MSDB.dbo.BackupSet

WHERE Type = 'd'

GROUP BY Database_Name

ORDER BY Database_Name

Shree-903371 (3/7/2012)

---

I have used a different way, it runs fine but it displays same vale if the date is same for two rows. Below is the example. Please see row...

Well done!

--1. you need some thing to uniquely identify each record and enforce the order

-- in which running total can be calculatedm based on your example,...

Having a SQL trigger sending email when data is changed is not a good idea.

However, you may still want to get email ASAP, faster than periodic job...

You can follow...

Thanks for posting DDL and data samples, only one thing is missing:

expected results. What exactly do you want to see based on your setup

Sean Lange (3/7/2012)

---

Eugene Elutin (3/7/2012)

---

Sean Lange (3/7/2012)

---

Eugene Elutin (3/7/2012)

---

Fasterst possible insert in T-SQL can be achieved when using SELECT INTO...

You will need to drop your table before doing so.

The next...

Yep that is right, transactional replication will not work.

Snapshot and merge replications will still work just fine.

Just was working on setting up one...

Sean Lange (3/7/2012)

---

Eugene Elutin (3/7/2012)

---

Fasterst possible insert in T-SQL can be achieved when using SELECT INTO...

You will need to drop your table before doing so.

The next option is to batch...