Hi - thank you very mutch for your reply.

In this case i can change the structure of the table because this is only a staging table.

This are tables created to...

HI- jerry tks for reply.

yes the table as the column.

You can see in the lines of the stored procedure (in read) the line:

"('ALTER TABLE bulk_provincia add CODIGOMAXIMO INT IDENTITY ('...

this is supposing you have the files of tempdb on the same disc conditions as the user databases.

Ok. thank you very mutch for your help.

Pedro

Last question about this subject if you do not mind...

Why did you put the:

"!="...

Ok. I understud very well tks.

sorry to take your time, colud you explain me how to do this but without the Xact_abort? so that i can learn the two ways?

I...

Is the, xact_abort ON, only enabled while the stored proc is executing?

Don't i need to put the set x_act_abort to off, on the end of the stored procedure? after the commit transaction?

What i whan't is that this procedures only commmits the 3 updates if non of them fails.

How can i code the procedure above, so that only if the 3 suceded,...

because i would have to make the APP that inserts the dates into the fields and i can not do that, because it's not my app.

tks,

Pedro

ok.

1) Some times i gain performance because of the GO in the meadle of the staments.

I don't know why....

Suppose the two querys mencionated befour.

Why does the GO (bacth breaker) brings...

Hi - tks for your reply and your help.

Ok i undesrtud that querys are only executed when the above one as been executed first.

But in this case, if the ...

Hi - tks for your reply and your help.

Ok i undesrtud that querys are only executed when the above one as been executed first.

But in this case, if the query...

tks,

It worked very good....

Pedro

I just put what you told ADi, but i receive the folowing error, when running the query:

"Difference of two datetime columns caused overflow at runtime"

what can cause this situation?

tks,

Pedro