Please see the first link in my signature about best practices when posting questions. From what you posted nobody can run any code and we have no idea what you...

Thanks for the sample data and the stripped down version. Reading this again it is obvious that what you need is to read the article I suggested about splitting strings....

fwob04 (11/7/2012)

---

As I mentioned previously there are several more tables involved. If one of them is the "key" table in the database, that archives one would be it, so...

Matt Miller (#4) (11/7/2012)

---

Sean Lange (11/7/2012)

---

Matt Miller (#4) (11/7/2012)

---

Sean Lange (11/5/2012)

---

yogi123 (11/5/2012)

---

Hello

I need to delete 1000 rows from table and it should do it batch wise.

means

i need to loop delete...

Hi and welcome to SSC. It is very hard for somebody to understand your exact problem here because we have nothing to reference (tables, data, etc). It seems that part...

I don't have code for creating the database. As I indicated previously, I didn't create the thing, I just get stuck cleaning it up when the end user does something...

Insert statements.

Take a look at the first link in my signature about best practices when posting questions.

Matt Miller (#4) (11/7/2012)

---

Sean Lange (11/5/2012)

---

yogi123 (11/5/2012)

---

Hello

I need to delete 1000 rows from table and it should do it batch wise.

means

i need to loop delete statement that delete top 1000...

river1 (11/7/2012)

---

That updates the entire table!

I have deleted my first trigger and created a new one based on the code changes you told me.

The trigger is now like:

USE [SGCTCentral]

GO

/****** Object:...

Just checking here.

I...

river1 (11/7/2012)

---

I dont understand the code below:

update contribuintes

set

nif = d.nif,

...

Your trigger needs to be completely rewritten. You can't handle multiple row updates. This whole thing needs to be set based or you...

**groan**

Yes this is no problem. Even though this link is for 2005 it is the exact same process in 2008, not sure about 2012 since I don't have it.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d91d265a-59d3-4c8a-94ad-227611c342d8/%5B/url%5D

Is the datatype for archiveID int? Do you have any triggers on these tables?