I have a db that has over a million transactions for a year period. I have been tasked to analyze these transactions and determine patterns in terms of peak hours...peak days...peak weeks.
(fields 1,2 and 3 will be relevant later when I want to determine the average number of items per transaction per hour)
I am thinking that this will be a fairly huge task if it is possible so I will start with baby steps...
Logic pseudocode...break each day down into 24 hours and sum all transaction for each hour and then group by week...I guess the only way to determine patterns will be to look at the 52 weeks worth of numbers and determine if there is a pattern...unless of course someone else has done this and has a better idea...again totally out of my element here but there must be a way to do this...
I will carry the other steps into other questions with additional points once I get rolling on this one as although they are realted they stand independently of one another.
thanks for any sql starting points...groovymonkey...