Kenneth Wilhelmsson (11/1/2007)

---

I don't see the point with that demonstration of yours, it seems to be about something that hasn't yet come up anywhere in this thread?

Would you care to...

I used loop to guarantee the order of INSERTING the rows.

Are you agree that ORDER OF INSERTING was the same for both tables?

So, what the SELECT proves in this case?

P.S....

Kenneth,

they are too dumb to put some effort into explaining how SQL Server works to them.

Perfect members of the community. 😀

They were informed about the error right in the...

And clustered index on DATE columns for both tables would help A LOT.

If it's impossible try (not on production, if possible :))

[Code]

DELETE A

FROM TABLE_A A

INNER JOIN (

select...

Then go with your loop.

Just add

WAITFOR DELAY '00:00:02'

to let other Server to pay attention to other processes.

You may also include something like this:

[Code]-- Before entering the loop

...

It's done in front end application - EM.

Same about datetime values.

These are kind of contradicting each other:

/* update all users in same agency profile */

....

AND [UserId] = @Original_UserId);

Second update does not look right to me at all.

Not because of SQL...

rmcknight (10/31/2007)

---

Sorry for the confusion.

I'm looking for gaps in the sequence. The ID and Code are just record fields, and I need to know if someone skipped a sequence number....

I don't care about entire...

If they believe they know how to do database and queries, and you think they don't then don't argue, just sit and prepare set of scripts to populate their tables...

Another thing:

1st query will perform one transaction, 2nd will do 2 transactions.

But your performance hit definitely is caused by grouping invoked by UNION.

You should also take into consideration the fact...

Nobody is perfect.

Don't ever copy someone's words without good thinking about it, no matter how...

David, you should take care of it in front end.

If value in text box is '' then you pass NULL in SP, if it any kind of integer value you...

You declare a...

With what?

'Not always useful' does mean that it does have it's usefulness?

At the end of the day, the execution plan is what decides how things...