Just started here, so here's what I got. I would ask the developer, but he's already gone (now I see why;-))

We are trying to pull leads from a table that...

This is my second week here and believe me it's worse than it looks.

We are in the process of re-designing our entire site, but until then, I've been asked...

I was trying the same thing a while back and ended up using a SP that I found on this site -

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=900

right, thatwas the first thing we did, but saw no difference in performance..

Anything else I could do? or look at?

We are using the The 64-bit Intel Itanium.

Any help would be greatly appreciated.

Thanks

Susan

Thanks for the help.

It's exactly what I needed. You guys ROCK!!

Is your reporting server located on the computer your working on ?

If not you will need to change 'localserver' to the name of the machine with reporting services installed.

Thanks for your info.

I went ahead and changed the update statement and will test the timings between the temp table and table variable.

Thanks again

Susan

In case anyone cares.. Here's what I ended up using..

CREATE  proc UpdateEmailStatusMaster

@process_date datetime

as

declare @email_sent_date datetime

Declare @updateemailsm table (pk int identity(1,1), consumer_id Int, email_sent_date...

Thanks for the help, I thought of that but couldn't that possibly update the same data?

How do I ensure all rows needed are being update?

Thanks.. I will find my post and send it on to you..

But the general link is

http://support.microsoft.com/newsgroups/default.aspx

then drill down to servers/SQLServers and you will find the topic breakdown..

One last...

Thanks for the quick response.. I was right.. it was user error

I ended up trying the proc on another server and it worked like...

This is TOTALLLY AWESOME and EXACTLY what I was looking for!!

I've been trying it out this morning and am running into some user error on my part I'm sure..

Here is...

The example is commiting every 1000 records.

My requirments were bring in no more than 100,000 rows then execute the inserts 1000 at a time.

Hopefully that's what you were referring...