I'm including the Time / IO Information to demonstrate the reads:

(36278 row(s) affected)

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0

Table 'GICSPFProductToZone'. Scan count 1,...

What have you tried to far? If it's THAT urgent, you must have worked a bit on it?

You know, people that help you are on these forums aren't paid...

You have a big problem with the client application. It must NOT call once per row to get the information, you have to find a way to revamp the procedure...

Good Question! :w00t::w00t:

How do you build your update queries? From what field do you base your statement to be able to generate the update queries?

Because we could change that, and therefore run...

From what I can understand, your update query hits 5 million rows.

The only filter that is in your update is the PageID, and FileID, and you said you were able...

You're welcome,

Thanks, I'll do some reading, looks interesting.

Anyone has a link for that "Magical on the fly tally table" as

with cte as (Select 1 union all select 1 union all select 1 union all select 1)...

Thanks for the vote of confidence Jason, 😛

We do not know if the OP has...

Here is a query you can use, but you will need to add a datetime field you probably have in your table in the sorting. It's just a working idea...

You want the "First" record for this grouping, but based on what criteria? Do you have a Timestamp for the order the records were inserted in? Otherwise, there's no way...

Ryan, I've come with a small test table, that makes me doubt over your statistics.

IF EXISTS ( SELECT 1

...

I have not tried this, but I would try to update the statistics of the temp table right after the insert, so you can make sure it will use the...

Neone looking for a short hair curler? That could do me some good! Haha!

http://www.sqlservercentral.com/Forums/FindPost879666.aspx