Apologies I pasted misleading info the table should look like this

ID DATE REGION BRANCH SALES ...

Thanks for such a quick reply djj

I should have realised thst was the solution!

Much appreciated.

🙂

Thanks everyone, particulalrly Michael, you guys have saved my bacon!!

BO:-D

Hi

Yes, the recent 'type' would be used as the basis to update the archived record...

Thanks to you both I'll give it a go...

Doesn't bcp lose the headings? Or do you have example script that retains these during Export?

Only that that the flat file option is proving problematic...

I was thinking perhaps the script would be more dynamic...

Thanks for the speedy response...

The whole purpose is actually to try and forecast for the forthcoming year based on last years performance but the file does not contain the Sales...

Guys

This all really very, very helpful and I will have a play around and see what I can come up with.

Thanks in particular to Alan - especially as you had...

Hi Lynn

Is it possible to adapt this code slightly so that rather than updating the sales figures for a specified product type ie LEISURE. It creates a new product type...

Worked out the issue and works great..

Thanks for you help!

BO

This sounds like the perfect solution but I'm getting the following warning when I paste the code into my report item which prevents the report from rendering:

Deserialization failed: The element...

Perfect!

Thanks for your speedy response....

BO

Cheers Luis

This works great but like you say the data will need a little tweaking...

The following code only joins on the first four records in #TableRegionOther when I want it to bring back everything apart from (' SouthWest ', 19)...

Any clues as to what...