dapcigar Posted March 2, 2015 Share Posted March 2, 2015 Dear all, Please i need help with something. I have some data in a particular table called "Requisitions" now i want to sum up all the values in the table by categories and then save it in a table called "transaction log. is there anyway i could achieve this by writing a script that does that automatically for me? thanks in advance Quote Link to comment Share on other sites More sharing options...
Barand Posted March 2, 2015 Share Posted March 2, 2015 Yes, you could write a single query to do that, but why bother storing data that can be easily derived by the same query. A basic principle of db design - don't store derived data. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.