Great! Thanks for the feedback, it is good to know that my suggestion helped.

Create a restore job and use it for every restore. Then you'll be able to see the duration in job history. In case you need to keep track of restores...

Well, obviously your SQL Server decided this morning that it had enough fun and started to work normally again 😀

I'm glad we were able to help... good luck!

SQL33 (12/7/2007)

---

I think perhaps a better explanation would be helpful ... each custlink can and does exist in multiple rows, each in turn has a field containing a unique sequence...

SQL33, johnsql,

as several people mentioned, there is no way to say what is sequence number of a row, if you don't specify ORDER BY.

Rows in a table don't have any...

Just one additional thing: in case of some large scale operations (e.g. when inserting large amount of data), it may help a lot to drop indexes, perform the task and...

Please, could you explain it in more detail? I'm not sure I understand it correctly... it might be, that you are trying to create a common ID for the two...

Mark,

my experience is, that if I can't put what I need into words, it means I don't understand it well enough. Trying to describe the problem as accurately as possible...

I'll use the table structure and data from previous post.

If there is a possibility of multiple occurence of the same "sequence" value for one cuslink (shouldn't be, if that really...

Karim,

a lot depends on the way how data is inserted. Please follow Gila's suggestion and run Profiler trace to find out what happens on database level when the software inserts...

Mike Levan (11/8/2007)

---

tableA(empid(PK),empno,last,first,jobno,jobname)

I have inserted data into tableA except for jobno,jobname which will be null for this insert

now i have into insert from tableB(1 row) into tableA with fields...

Yes, we understand that. That is also the reason why everybody is asking you to post

1) the entire trigger (in case you posted only a part of it)

2) statement...

Hello Theo,

as far as I know it isn't possible, and even if it was, I don't think it would be advisable. A trigger calling SP also isn't the best solution,...

I'm afraid a lot can depend on the other, not mentioned things you're doing with data in this procedure... but generally, you can concatenate lists using UDF:

/*sample data*/

CREATE TABLE yourtable...

As Sergiy already said, first thing to consider is how to get needed result without resorting to row-by-row processing - no matter whether it is a loop or cursor. I've...