ABSOLUTELY

I used the GOTO's to separate the code and make it more readable. I absolutely hate not using indentation - that makes code very hard to read no matter how...

please remember that my company is still using sql2000 - so WHILE does not exist for me

ignore that kind of thing - I was jsut trying to remove the sensitive information, rest assured that there is nothing like that occuring in the code - please assume...

am sending the code for my SP. It is severly gutted and memvar, table names, etc have been made more generic. This is due to company policies. It shoiudl hoever,...

I am no longer certain as toe what you mean by nested. I am VFP programmer from way back in the days of dbase. Very littel basic experience.

SQL...

I don't know or remember - it was one of the respondors to this thread.

I don't advocate nested tranactions either, I only wanted to perform the transaction in separate SP and then based on their return values, I would commit or rollback as needed.

Don't...

wild guess SAVE POINTS is a sql 2008 thing right

thanks:D

Great Advice all the way thru - thanks. Since it is so good I will answer each one:

1. I absolutly agree with this logic - that is why I wanted...

Understood. We are taking this too far. I really appreciate all the assistance I am given. 😛

2 Items:

1: You mispelled your

2: I never said or implied that triggers were stupid. What I said was that the builders of the program that created the database...

you are offensive - maybe because you lack the skills in the use of the english language. YOur use of "tiny experience" and the word stupid is offensive.

I have been...

you are prettey arrogant and well, not a very nice person. No need to be so condescending because one is not as experience as you are.:angry: