If those are not around, then how come the server be up and running??  Are you sure that the server is running?  Are you sure you checked in the Master...

Search parameter sniffing on this site.  There must be 100 threads talking about this.  If you still have questions, I'll gladly adress them after you gave this a try a...

Was the problem in a newly restored database?

In a newly installed database?

Found any errors in the scripts that were ran?

Or maybe some scripts that were not run?

Most likely that a new set of parameters was passed to the stored proc and the cached plan was not optimal for those parameters.

Check out parameter sniffing on this site...

Here's the correct syntax to do the update.

UPDATE A

SET Col1 = B.Col1,

col2 = B.Col2,

Col3 = B.Col3,

Col4 = B.col4

FROM Table1 A inner join

(SELECT Col1, Col2, Col3, Col4, id FROM Table2

UNION...

You can or you can't imagine any reason?

You can do a union all between b and c and use that data to do the update.

Or you can simply do 2 different updates.

What is this doing in there?

DECLARE @val bigint

SELECT @val=COUNT_BIG(*) FROM Table1 WITH (READCOMMITTED)

Can we see the rest fo the statement, maybe there are other alternatives to this problem?

Why are you not joining simply on the id column(s)?

Try changing the update query to a select and see if it returns row(s) (which I would think not).

If no rows...

What error are you getting?

What is not going on as you'd want it to go?

Why not simply drop the destination table first, and then reimport it?

Thanks for sharing this with us.  Care to write a small article about this one and submitting it to Steve ?

It's kind of hard for us to help you if we don't know what's going wrong with your code!!

A date is a place in time, hence you can't have a date without time.  If you don't want to display the time you can either have the application hide...

Or another way to do this :

- Insert into temp table in the correct order

- Run a single update statement calculating the running total

- Select from temp table

Option c...