Thanks Jeff, will do.

Thanks Chris, this is awesome. Will go ahead and include all the other required bits and see how I get on with it.

Thanks

My apologies Chris, the table has a huge host of columns so had to pick out the relevant ones. I have redone the script and data capture as well.

oops, forgot this one!

Here you go Chris.

Thanks

All attached.

Sent PM again. HAve you received it??

Would appreciate your input to this.

Script doesn't quite work. I'm not getting the values expects, getting 0s and nulls. What is wrong?? Have attached attributes for both tables.

SET NOCOUNT ON

DECLARE...

Sent via PM. Would appreciate your ideas. Thanks

The problem is with the last part of the script, insert & select. Obvioulsy, as new_cost doesn't exist in the sales table, the calculated data needs to go somewhere in...

Hi Chris,

Script doesn't quite work. I'm not getting the values expects, getting 0s and nulls. What is wrong?? Have attached attributes for both tables.

SET NOCOUNT ON

DECLARE @income money,

@cost money,...

Hi Chris,

Does this means I will have to introduce a new column, newcost, to the tmp_hhrsales2 table?

HAve attached the table attributes which includes indexes. Pls let me know your thoughts.

What do the two changes you've made do, how do they affect the data??

Don't know why a trigger or any other option was not used, just inherited the package.

Could you give an example script of your idea pls?

Yes, the clustered index on TransactionID and Date.

I did try Chris' suggestion with the calendar table, it did make a huge difference. Anyway I can optimise it further looking at...