Hi, I have a MSSQL 2005 database with ~400.000 lines in a table. One column has a date format like this: "27.05.2007 13:44:00". I need to count all lines with the same date for a statistik, so that afterwards I have something like
27.05.2007 350 rows 26.05.2007 256 rows 25.05.2007 180 rows I couldn't create a view that works good (sorting was the biggest problem there), so I thought I write a perl script to does it. I'm not quite sure, though, what the best way to it would be. Should I read all lines into a hash, then count and sort? Since the database grows, this could be to slow someday... any ideas? Lars _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
