How Did I Do That?

August 11, 2010 Hey, Ted

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.

–Justin

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