(no subject)
It would seem I'm impressing people with my unconventional thinking and programming prowess again. Unfortunately, for all you non-techies out there, I shall not be providing a translation.
Our developers came up with a Excel spreadsheet that uses VBA to make a SQL query to an Oracle database to populate the sheet and perform some additional manipulations (specifically, a VLOOKUP on a couple of the result fields). Unfortunately, we discovered today that the VBA-embedded SQL query needs to check date ranges to accomodate the customer's request. According to the guy working on it, it's gonna take a couple of days for him to change the SQL, verify it works then convert it into VBA.
When I was suddenly given a whole lot of free time when the network connection to California went bye-bye (wild fire 1/2 a mile from the school I was connected to, apparently), I decided to see if it were possible to create the same data using just SQL. Using assigned variables and a really long DECODE statement, I was able to approximate the VLOOKUPs and duplicated the Excel spreadsheet. Now that's done, I can add in the date range criteria and any other little tidbits we need and poof! there's the data.
One small downside: it has to produce a fixed-width format text file. Assuming I can't find a way to do it with SQL, we'll have to go back to a VBA SQL query. Assuming my new query won't make Access puke, the developer wants to use Access instead of Excel as I'm already running an Access report for the same school that's due at the same time.
Long story short, I greatly outdid myself and, as a result, there were lots of kudos and "That's really good!"s being tossed in my general direction.
I rule. *insert happy dance*
Our developers came up with a Excel spreadsheet that uses VBA to make a SQL query to an Oracle database to populate the sheet and perform some additional manipulations (specifically, a VLOOKUP on a couple of the result fields). Unfortunately, we discovered today that the VBA-embedded SQL query needs to check date ranges to accomodate the customer's request. According to the guy working on it, it's gonna take a couple of days for him to change the SQL, verify it works then convert it into VBA.
When I was suddenly given a whole lot of free time when the network connection to California went bye-bye (wild fire 1/2 a mile from the school I was connected to, apparently), I decided to see if it were possible to create the same data using just SQL. Using assigned variables and a really long DECODE statement, I was able to approximate the VLOOKUPs and duplicated the Excel spreadsheet. Now that's done, I can add in the date range criteria and any other little tidbits we need and poof! there's the data.
One small downside: it has to produce a fixed-width format text file. Assuming I can't find a way to do it with SQL, we'll have to go back to a VBA SQL query. Assuming my new query won't make Access puke, the developer wants to use Access instead of Excel as I'm already running an Access report for the same school that's due at the same time.
Long story short, I greatly outdid myself and, as a result, there were lots of kudos and "That's really good!"s being tossed in my general direction.
I rule. *insert happy dance*