Thanks -
Yes unfortunately the ERP system does, Inventory, Customer, Suppliers, but not LEDGER chanegs - which is a blackhole - so I have just replicated that they do and ... well its been signed off by the FD - so I am happy 🙂
I am sure there will be more to do though ....
Am looking forward to my SQL BI in 3 weeks time 🙂 might help my reporting techniques further.
Cheers
Steve
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.