Since the IO processing from a cursor is not efficient, what are some other alternatives? I know it will vary on the situation but, are there some things I can...

Thanks for the help Matthew.

Thank you very much for the suggestions - I will take a look.

Thank you Scott.

I think after further research it's not so much to do with the sp but with the DB servers resources.

Thank you

I guess the main problem is that it locks up the system for a long time. Within our application, the system will hang for about 10 minutes when this occurs.

I'm not a dba and I don't think I can view the locks but our consultant said we experienced a lock. I am just trying to figure out why the...

Jack,

Thank you very much for atking the time to help me out - I will try it out.

OK, thank you. I will produce data , etc. and return when I have the information.

Hey Joe,

Thanks for taking the time to answer. I did some studying and really liked the isea of a MERGE as presented by a previous poster. However, I couldn't get...

OK - I will move it.

Thanks

How would "Merge Replication" work? Is it reliable? What is the potential for data conflict pushing and pulling?

I guess I am just wondering how well this works in the real...

The database is not huge but it's not small either. However, to run their application we're probably only talking about 30 tables which is not big at all.

As far as...

From my earlier post:

"However, just running the primary select statment just then took me 1:17 to return 14,765 rows. But, again, am I barking up the wrong tree if I...

0.0022522524car_init

7.579777E-0610car_init, car_no

1.014066E-0618car_init, car_no, ship_date_time