You're welcome.

Look into what "ACID" means with regards to databases and transactions. That'll point you in the right direction on this.

I...

rjv_rnjn (8/18/2009)

---

GSquared (8/18/2009)

---

On the column aliases, I do that to keep track of which source column is going into which destination column. Of course, I write my inserts explictly...

You'll either need to modify the FK constraints so they cascade, or you'll need to disable them during the update and update each table individually and then re-enable them.

kabaari: It would be helpful if you posted using the code blocks. Then your code and data would be visible on the page.

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now and I fear...

This would be a database change.

If, on the other hand, sorting is causing the problem, have you looked into your execution plan? You're probably missing an index that'll make...

For that kind of situation, your best bet is usually to insert the data into a table that has a session ID in it, and the row numbers, and then...

Only way I know would be turn that into a CTE/derived table, and join to it to do the update.

I had completely forgotten about NOEXEC.

Will this do what you need:

select top 25 * , ROW_NUMBER() over(ORDER BY lead_stage DESC , Lead_LeadId DESC ) AS rowranking

from vListLead

WHERE Lead_AssignedUserId=523 AND lead_status = N'In Progress'...

The transaction log in this kind of situation is being used as a data safeguard. It helps prevent the database from becoming corrupted by partial writes and things of...

On the column aliases, I do that to keep track of which source column is going into which destination column. Of course, I write my inserts explictly instead of...

You might be able to get that from the log files. If the database is in full recovery, get a log parser and see what you can find.

Otherwise, this...