the below will work but the order id's will be recreated in table a and therefore they will change. Is that a problem? Do you want to keep the order...

damn right it does. Serious brain fart on my part. i suppose i'm over thinking. Thanks for clearing that up.........

not sure if it returns what u want. i added a bunch or empty strings in the areas when you had no "THEN" value. therefore if either of the following...

--u need something in every then statement and your formatting was jacked up a bit.

SELECT p.idpeople,

CASE

...

maybe i'm wrong. i assumed it would continue w/o waiting for proc to finish. i will have to test now to find out for sure

yea. if u notice the actual proc call is dynamic sql. it just kicks off and then moves on. it wont wait for completion to move on. it's dynamic sql...

not everyone at once here. I can only handle one reply at a time.

i fopund a way to do this using the waitfopr command however just not sure if it's...

i see. And just to clarify you basically want to move whats in b to a. There will be no actual addition correct?

i just thought of something while in bathroom. i suppose i could have each proc set a flag in some table upon sucessful completion that i can check it's value...

Just an FYI here. If you want traction from your post you will need to supply more info. These guys are quite incredible as a resource however they won’t waste...

Noted. Thanks J.

Nixed the solution. He's big on keeping things as simple as possable for easy debugging purposes. As i mentioned before we're monitoring serveral different apps accross 50 or so sql...

sorry. Nixed it on the spot.

thanks for the solution. unfortunatly my mngr over heard me discussing your sol w/ a teamate and he hixed it on the spot. I appreciate the solution though.

i've been using the below and running accross multiple boxes using open query to give me all table changes as well as others for change monitor. Works in 2005 and...