|
Sounds like he could drive you to blow this(6)
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
And we talking rainbow here? 'Cause that might be a bit UK centric for most ...
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Rainbow ? too many letters it isn't uk specific
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
That's a relief - my initial thought was BUNGLE[^] 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I would never put a clue up that required you to have tv knowledge( I don't watch it ) 
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
Sounds like he could drive you (chauffeur) Shofar
Shofar is a horn
[^]Shofar - Wikipedia
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
|
You don't need to watch tv to know what a chauffer is 
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
pkfox wrote: You don't need to watch tv to know what a chauffer is
No. but generally we can spell it...
Oh well, I learned something: Jewish Horniness exists. 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I did spell it correctly in the solution
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
Are you going to spell it correctly into today's CCC?
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Also known as the story of the natural key that wasn't.
|
|
|
|
|
Jörgen Andersson wrote: Assumtion is the mother of all f***ups
I'm assuming you are talking about poorly gathered requirements. 
They tell you to build something. Then later they tell you, "no, not that." 
|
|
|
|
|
raddevus wrote: I'm assuming you are talking about poorly gathered requirements.
Yes, but not just.
I've inherited a database and has been given the task of making it work according to new intentions.
And while it's actually quite fun most of the time, I would at other times find it even funnier to meet the original designer and teach him the virtues of normalization using a bundle of nettles.
modified 23-Oct-18 18:00pm.
|
|
|
|
|
Is it at least in 1NF?
|
|
|
|
|
Mostly.
The biggest problem is that he didn't have the domain knowledge to use the correct keys.
Then again, he's been using a surrogate key (identity) for a year table. Yes, it has two columns (YearID, Year) .
|
|
|
|
|
SELECT
FORMAT(y.Year, '0000') + '-' + FORMAT(m.Month, '00') + '-' + FORMAT(d.Day, '00') AS OrderDate
FROM SalesOrder o
JOIN Year y ON y.Id = o.YearId
JOIN Month m ON m.Id = o.MonthId
JOIN Day d ON m.Id = o.DayIdYou mean there's another way to store dates?
|
|
|
|
|
Apparently there are a few. Sometimes more than one in the same db.
|
|
|
|
|
Jörgen Andersson wrote: Yes, it has two columns (YearID, Year)
That'd be hysterical if it wasn't so tragic.
"Never attribute to malice that which can be explained by stupidity."
- Hanlon's Razor
|
|
|
|
|
Ha! I'm in the same boat.
I need to scrap an "obsolete" database-listener service.
And they also want to retain all the functionality, like performing manual edits in the database should still trigger various workloads.
*sigh*
|
|
|
|
|
Jörgen Andersson wrote: teach him the virtues of normalization using a bundle of nettles
That's so environmentally unfriendly of you. A few strokes, the nettles wear out, and you have to harvest more.
I prefer a bundle of rusted barbed-wire scraps. They last forever, and the extra weight adds emphasis to the stroke.
Software Zen: delete this;
|
|
|
|
|
I had a customer say to me once, "I won't know what I want until I see it." Yes, that is a direct quote. He was definitely the worst customer I have ever had but there are some serious contenders. The top two are both quite large companies and I do everything I possibly can to avoid buying their products.
|
|
|
|
|
|
Rick York wrote: "I won't know what I want until I see it." Yes, that is a direct quote. He was definitely the worst customer I have ever had
Really? That is pretty much how all customers are. They might know what they need it to do but as far as UI design, for example, they have no clue what they want until they see it. That's pretty normal in my experience.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
It is quite far from normal in my experience. My customers have run the entire spectrum of zero specifications to every detail fully specified down to the colors of the items on the user interface displays. Even those with no specifications would say things like "do it like this one" or "do it like the last one was." In this customer's case, they actually had a specification but this guy treated the whole thing as being optional and we were at his beck and call. He ended up delaying the project so badly that when we were asked about it we said because of (this guy) and when his bosses saw the absurdities things were changed in a big hurry.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
