Denise,

This is the revised code. Problably the first part of the statement won't help because it is calling fields from local views and tables, but the WHERE section is the one...

Thanks. That's what I ended up doing and it worked fine. Thanks again.

Frank,

I heard from many SQL programmers and DBA's to stay away cursors. What other way can you run something like this:

/* Variables that table info is read into. */

DECLARE @StartDate...

Thanks Jeff. The query is fine. I did run the plan to check it out and there is no problem there. I think we nail this thing down with some...

Thanks Frank. That's what I thought.

Great!! Thank you all. I think we figure out at the same time you guys were responding. Thank you anyway. I run it with the @@error for each statement in...

Yes, we do. It runs from the application, which is asp.net based. We modified the timwithin the application, but still times out. Thank you. Are you from Aregentina? I think...

I did answer Enterprise editon based on the remote location you need to replicate. If the replication is same office, well Standard is more than enough. If is a remote...

I am not a guru, but the PK are essential to the design of the database, otherwise how do you know if you have that record already in any particular...

Thanks to all. I will test the CASE option as well as the view. The temp table could be an option later. I created a store proc this morning and...

thank you Jonathan. As you can see in the sample I posted, that is what I did, but using query analyzer.

My question was, and I am sorry if I...