If only I drank Coffee I might have figured out what I was doing wrong awhile back.

Found what the root of my problem was.

Matt,

That is exactly what the book I'm trying to learn from says to do, however when I click to the next report I receive an error about the Paramater being...

I had this problem awhile back, and one of the ideas that was given was to make absolutely sure there were no indexes,etc on the databases that was being imported...

I just saw this thread and am now semi confused.

I too have a Windows 2003 (32bit) server running standard edition of SQL 2000 with 4GB of RAM on the machine.

I...

Actually I use that to make sure that when the procedure is called it goes with quotes around the fields to ensure that since they are all based as varchar's...

Somedays it helps to proofread code I think.

One problem I just found in the proc is my set @Phone=(select phonenum from line).

I'm working on changing it currently and will re-test...

Tim, here is the code that the while statement is calling and as you can see with the dynamic SQL of @SQLU being built, while something as simple as an...

Honestly Tim, I'd love to solve this problem because the routine I'm using takes literally 8 minutes to update 25k rows against a 4M row database (it's horribly written and...

I've tried it using (nolock) and without and everything I did ended up still causing a ridiculous amount of time to do the inner join update.

Therefore, I took a hybrid...

The Motorola Razr phone has everything you're asking for except for one-touch voice mail (which technically you can program into the phone to do this).

The battery life on mine is...

Plan for the select query (where I inserted the records to a new table)

  |--Compute Scalar(DEFINE[Expr1002]=right([C3].[PhoneC3], 2)))

       |--Nested Loops(Inner Join, OUTER REFERENCES

I understand what you're meaning now.  I just wasn't sure.  I am currently sending all of the records via a select statement into a staging table, which will allow me...

I'm confused Tim, what do you mean with a staging table between?

Are you thinking I should take the clustered index off the table I'm trying to update in order to...

If I run a select query it's almost instant doing the comparison, but when I try to run the update it doesn't matter if I try to update a thousand...

The statistics should be up to date, both of the indexes were dropped and recreated earlier today as I was trying to troubleshoot the delay.

If my issue with char comparing...