RE: cross tab needs in SQL

-----Original Message----- From: bozon Sent: Monday, January 09, 2006 9:42 AM This sounds like a job for PERL. Do you have access to it and know it a little? It processes this kind of thing quickly. You can probably find an example on the web. I am no expert (I only do small things in it) but I could cobble a fast enough perl version to flip data the way that you want. I think Jonathan Leffler is an expert on PERL so he might be even better suited to comment on this. _______________________________________________ We have PERL, but I don't know PERL. :( I've just recently found a decent AWK tutorial. I'm not a programmer, just a desperate data&DBMS manager trying to support our customer with no real help outside of our own ingenuity. It's kind of sad that this is the way we live, but it keeps me employed. :) Rob