How Did I Do That?
Published: August 11, 2010
Your tip for building spreadsheets from SQL statements is spot on. The problem I used to have is that people would come back to me days, weeks, or even months later, asking for me to rerun my query to give them current data. I no longer have that problem, and here's why.
After pasting the SQL data into the first sheet of my Excel file, I copy my SQL command(s) into the second sheet. When the user asks me for a data refresh, I open the spreadsheet and retrieve the SQL. No more time wasted looking through my SQL history.
FROG: PC-based SQL for DB2 for i
Post this story to del.icio.us
Post this story to Digg
Post this story to Slashdot