Welcome to the Lounge

23-Oct-18 23:05

I would never put a clue up that required you to have tv knowledge( I don't watch it ) Big Grin | :-D

We can’t stop here, this is bat country - Hunter S Thompson RIP

pkfox24-Oct-18 2:06

24-Oct-18 2:06

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

DRHuff24-Oct-18 3:54

DRHuff

24-Oct-18 3:54

Shofar???? D'Oh! | :doh:

Because requiring knowledge of tv would be asking to much?!?!?! Laugh | :laugh:

Socialism is the Axe Body Spray of political ideologies: It never does what it claims to do, but people too young to know better keep buying it anyway. (Glenn Reynolds)

pkfox24-Oct-18 7:04

24-Oct-18 7:04

You don't need to watch tv to know what a chauffer is Smile | :)

We can’t stop here, this is bat country - Hunter S Thompson RIP

OriginalGriff24-Oct-18 19:48

OriginalGriff

24-Oct-18 19:48

pkfox wrote:
You don't need to watch tv to know what a chauffer is

No. but generally we can spell it... Laugh | :laugh:

Oh well, I learned something: Jewish Horniness exists. Wink | ;)

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!

pkfox24-Oct-18 23:28

24-Oct-18 23:28

I did spell it correctly in the solution Big Grin | :-D

We can’t stop here, this is bat country - Hunter S Thompson RIP

Assumtion is the mother of all f***ups

OriginalGriff24-Oct-18 23:38

OriginalGriff

24-Oct-18 23:38

Are you going to spell it correctly into today's CCC? Laugh | :laugh:

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!

Jörgen Andersson23-Oct-18 9:34

23-Oct-18 9:34

Also known as the story of the natural key that wasn't.

Wrong is evil and must be defeated. - Jeff Ello

raddevus23-Oct-18 9:48

raddevus

23-Oct-18 9:48

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." Sigh | :sigh:

Jörgen Andersson23-Oct-18 10:00

23-Oct-18 10:00

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.

Wrong is evil and must be defeated. - Jeff Ello

modified 23-Oct-18 18:00pm.

Jon McKee23-Oct-18 10:55

Jon McKee

23-Oct-18 10:55

Is it at least in 1NF? Sigh | :sigh:

Jörgen Andersson23-Oct-18 11:28

23-Oct-18 11:28

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) Sigh | :sigh:

Wrong is evil and must be defeated. - Jeff Ello

Sander Rossel23-Oct-18 11:53

Sander Rossel

23-Oct-18 11:53

SQL

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.DayId

You mean there's another way to store dates? Big Grin | :-D

Best,
Sander

sanderrossel.com
Continuous Integration, Delivery, and Deployment
arrgh.js - Bringing LINQ to JavaScript
Object-Oriented Programming in C# Succinctly

Jörgen Andersson23-Oct-18 11:59

23-Oct-18 11:59

Apparently there are a few. Sometimes more than one in the same db.

Wrong is evil and must be defeated. - Jeff Ello

Nathan Minier24-Oct-18 1:23

Nathan Minier

24-Oct-18 1:23

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

KBZX500024-Oct-18 0:56

KBZX5000

24-Oct-18 0:56

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*

Gary Wheeler24-Oct-18 1:30

Gary Wheeler

24-Oct-18 1:30

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;

Rick York23-Oct-18 10:00

Rick York

23-Oct-18 10:00

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.

dandy7223-Oct-18 10:18

dandy72

23-Oct-18 10:18

Rick York wrote:
I had a customer say to me once, "I won't know what I want until I see it."

Real-life instance of Dilbert Comic Strip on 2006-01-29 | Dilbert by Scott Adams ?

ZurdoDev23-Oct-18 10:30

ZurdoDev

23-Oct-18 10:30

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.

Rick York23-Oct-18 11:38

Rick York

23-Oct-18 11:38

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.

Mycroft Holmes23-Oct-18 14:18

Mycroft Holmes

23-Oct-18 14:18

We have this as SOP, users come to us with an idea, partial spec is proposed and accepted, prototype developed and then the real requirements begin to emerge. Been doing it that way for 30+ years, I have never worked from a complete spec in my entire career.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

the goat in your machine23-Oct-18 18:30

the goat in your machine

23-Oct-18 18:30

Rick York wrote:
had a customer say to me once, "I won't know what I want until I see it."

Handled properly these are way better than clients that give you a whole mess of specs...
specs:
often in a small co: written by a boss who doesn't really know what the underlings need nor appreciate how it's done now and even less how it could be done better.
often in a large co: written by a bunch of ~~idio~~ "consultants" who get led around by a boss and never really ask the users as all they do is listen to the boss who <copy above="" item="">.

For mine, the less specs the better, talk to the users, don't ask them "what they do," but rather "what do they need to get done and what's the best way to get it done (with respect to, if any SOP)"

End result is a combination of application and business improvement, the staff will be happy, the boss will be happier as he gets happy staff and improved productivity.

Put simply: Show me someone that asks for specs and I'll show you a junior programmer.