Originally Posted by crazyap7
Oh my, that sounds incredibly painful
Damn databases, always needing to be fixed.
Yeah. Even though I made a custom interface to input the stuff, it was still time consuming. I think there were 20k+ check detail entries (stuff like gross pay, fed tax, state tax, unemp. tax, garnishments, child support deduct., etc.) and some 4k check headers. I did them all in about 55 hours.
And yes, I used to type really fast...when I wasn't so old
Originally Posted by Nude_Lewd_Man
I remember when I was working in the EU Helpdesk team (of 2) for a certain US bank [think: locks
] and I had to create a database of all of their IT kit, including serial numers and the device names...
At least I was able to notice their naming pattern, so I was able to generate formulae that would populate with the details - but that spreadie was pretty large (a few MB) and bl00dy complex too...after I'd left the other guy was 'stressed' as he couldn't work out how I'd done it or how I'd hidden a few pages where a lot of the formulae with too many nested formulae were...
I actually used some of what I'd used for that to create the new
(current) F@H FAT spreadie...just that I can't get GDocs to hide sheets, and there are only so many formulae that you're allowed to use, and some of those can't use the same as you can in an Excel spreadie...
Yeah, Google Apps stuff is kinda...strange. We worked with it here for a bit. Some of their tools we use, and some of them are...well...useless.
My favorite DB story was when I worked at a medical group as a programmer, and my boss the IT manager (who lots of people called "Satan" or "The Devil") had encrypted some tables in the SQL Server DB and thought they were unbreakable.
Needless to say when I needed some data and couldn't find him to unlock the table, I got into it. I knew a way to get around stuff. He asked how I did it, and I refused to tell him. He got mad and threatened me, and I said "Fine. But remember, I know how to access all your data."
He shut up real fast.
Of course, this is the same guy who had a huge ego because:
a) he was a former Army chopper combat pilot
b) former Microsoft higher-up (worked with Ballmer and Gates)
c) had a hot wife
d) thought he knew everything
d is no longer in his repetoire.