Rant

[Bunk]

I think you'll find this was done on purpose. You were supposed to hire them back to fix the mess. Their cunning plan obviously didn't work.

[HairyArsedBloke]

******* contractors!!!

I've just spent most of this week trying to make what should be a small and simple change to an ETL process. A task which has been made almost completely impossible by the horrendous mess left behind by whoever initially built it.
A massively complicated data model, spaghetti SQL code and no ******* documentation or comments.
6 tables where 2 (at most) would do
over 4000 lines of code in a single procedure which if it had a half decent data model could be done in 500

I've just crossed the point where it would have been quicker for me to redo all his tulip in a proper manner

*****

Sounds like one of mine.

Most of HAB Inc is like that - well, the best bits are.

[chef]

what's an ETL process? I never did find out but I believed I successfully hid the fact with my complex design.. you might want to find out before you begin, it may work better, again, I was too busy trying to stay awake..

[Spacecadet]

what's an ETL process? I never did find out but I believed I successfully hid the fact with my complex design.. you might want to find out before you begin, it may work better, again, I was too busy trying to stay awake..

In this case the T stands for "Toss around with the data for no apparent reason"

[chef]

In this case the T stands for "Toss around with the data for no apparent reason"

ahh perfect, combined with Extended and Learning I got it spot on then.. enjoy unravelling my code, it should help make the days fly by and no need to thank me for all the extra billing..

[thunderlizard]

what's an ETL process?

"ETL" is poshspeak for "move".