I will try to work on sample data and DDL info.... and post it tonight.

thanks

JG

I should add that the final result has to be the item, the location and the price

example if Loc1, Loc2, and Loc3 are part of Group1 and the item price...

normally it would work, but the t2 table is a table that contains locations and groups of locations and the master table is the item master which contains pricing for...

Hi sgmunson,

I can't touch the Master Table...

but a computed persistent column is virtual and calculated so it wouldn't affect the inserts or updates which might be a good idea......

The Network Administrator verified and found the place to change it... We can only wait and see tonight...

Thank you so so much!!! you just saved me many many more...

Hi Beatrix Kiddo,

Yes the transaction log backup that fails is the one that is taken during the VM backup.

We will find out a time range that the VM backup is...

VM Backup is very possible... I'll find out from our network admistrators...

As for maintenance jobs, we checked... they don't run at that time

(we do run a full backup...

This is the only place I found this solution!!! I had the excat same problem and you saved my day!!!

Very much appreciated.

Thanks you

John

Oooopps!!!! :w00t:

My eyes played tricks on me ... I guess my eyes are used to the name being under the pic... LOL

I guess an official thanks to Crispin Proctor is...

Thanks SSC Eights!!!

your command shell comment put me on the right track...

Using file system to store my package, I was importing the package into my Integration Services server but...

Thank you Lowell!!!!

WOW! I'm looking into your post and got me very curious as there's new stuff in there that I never knew about.

Thanks

JG

/* ************************************** */

The problem with using a stored Procedure is that I can't use the stored procedure in a insert into select statement for that field.

And... I can't insert all at once...

Very well said Hugo.

That's pretty much what I was trying to say although I wasn't thinking of Space (since today, disk space is pretty cheap)... your explanation is excellent.

Thank you...

oops... meant number of rows returned...