Can someone give me a hand with the sql (mysql works for me) for this rails project...
Data similar to this: Station Status WKRP Pending WKRP Pending WKRP Deleted WIBC Deleted WFBQ Pending WFBQ Nutty What I need is an sql statement that will count the various status states and return a *single row* for each station. Like: Station Pending Deleted Nutty WKRP 2 1 0 WIBC 0 1 0 WFBQ 1 0 1 I can get the counts of each station/status in individual lines and loop through the array counting the various status states, but the runtime for that is growing and I'm looking for a better solution before it becomes a problem. Ideas or suggestions?
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
