I'm still waiting for any type of answer from anyone to this comment/question to go any further in the process. Analysis comes first, not last

I think you have to create a perm table and drop it manually. The syntaxe seems to be the same between sql server and access. Also have you...

I can understand the split if you have 50M rows/merchant .

The only thing that could speed this up is to make sure that the...

is the data in a varchar column or an int?

Update table set column = left(Column, len(Column) - 4) where Right(column, 4) = '0000'

What is the filename of the db?

if it's .mdb then it's probabely an access db, else (adp), it's an access data project that is connected to an sql server.

To be...

Procedures in access mdb files?? That's new (to me anyways). Are you sure it's not and access data project that is connected on the server?

Maybe I wasn't clear with this message .

Shouldn't the data represent the correct value?? How can yo know the correct value if you don't know what the data represents?? I think you're going the wrong...

Check if there's a lock on the info you are trying to fetch.

run exec sp_who2 and check the blkby column for any spid -

then for each of those ids...

There's your problem :

"Due to some internal business rules and for faster data retrieval we have to store each merchant's data in its own table. I have a SP...

Now you kow why Expert Exchange has a monthly fee . Coding the thing is nothing compared to maintaining it.

Amen!

Making ssc a better place is not a moo point Sushila.

bkelley. Let me rephrase that : takes a lot of man power. Each post has to be read...

Maybe we should ask for a point/feedback system like the one on ExpertsExchange (assuming we can have the man power to employ it).

I just saw the title and the poster and I said to myself : Here we go again.