I have two complex databases each with over 100 tables. We have a DTS process that runs every night to update some tables with key performances so our clients can create their own reports with ease. Each of these tables is populated by a stored procedure that calculates and puts these key performances in there respective tables. They then run reports the next day on all information from the previous day and back.
Is there a way to supply these tables real time?
ALL IDEA’S GREATLY APPRESHIATED!!!!
Thanks,
Eric
Is there a way to supply these tables real time?
ALL IDEA’S GREATLY APPRESHIATED!!!!
Thanks,
Eric