@Zikato admittedly I did not spend too much time on this

@Zikato One of the best things to happen in chat.

@bbaird I enjoyed this too haha.

The stupid Advent of Code day 7 took me like 2.5 hours.

Morning

twitter.com/bbcworld/status/…

@JoshDarnell I'm running behind. Usually, it ramps up difficulty after day 6 or so. I'm thinking about using nested sets somehow

Also, morning :)

A chairde - Morning all!

The Invoice should be a John Grisham novel

@ErikDarling +1!

Lemme guess - Southern lawyer discovers that a big company issued an invoice (neither too big nor too small) to his (obviously innocent) client and then the client was sued by said company and couldn't afford to contest it. The lawyer investigated and found a couple of dead PI's and that this company didn't actualy trade - just issued invoices (your company perhaps? :-) ) - but the thousands of invoices issued added up to a significant (i.e. worth killing for) sum.

Of course, the lawyer then turns the tables on said company and issues them with a huge invoice which, by various tricks and chicaneries, he manages to finagle the money out the company and reimburse his client and all the other swindled people - plus hefty compensation (packages delivered by courrier) to the PI's families.

Whadda you think? BTW, John Grisham, if you're reading this - I want 50% of gross!

Oh, yeah, and all the execs of the company are jailed for long terms!

That’s about the formula

Throw in a female lawyer that everyone underestimates

Put that as a prompt for ChatGTP and you got your novel

@ErikDarling And ditto a black PI? I think I'm in the wrong business!

@Vérace maybe Santa will bring you a typewriter for Christmas

I'm not Miss Marple - I do actually know how to use a laptop! And I'm a touch-typist!

ok, sweet feature alert. Editing T-SQL in Visual Studio allows you to automatically expand SELECT * into SELECT with a list of columns, prefaced with the correct table (or alias). Just right-click, hit refactor, and "expand wildcards". What a time saver.

Oh, that's cool.

especially since it automatically prefaces each column with the table alias. What a time saver.

It would be really great if it could automatically add statement terminators, too.

I sense a lot of automatic refactoring that could be enabled.

lego.com/en-ch/product/typewriter-21327

@Vérace Now you know its fiction. (Reads news about Theranos) Well, maybe...

Yesterday I learned my boss's boss's son works for Lego and gets a pretty steep discount. Thinking about a career switch.

Wife: "We can't live on this salary! You spent the mortgage on brown 2x1 peices!" Me: "THINK OF THE MONEY WE'RE SAVING PER BRICK"

@HannahVernon that's sql prompt, you're welcome

is that a Microsoft product?

lol

but I appreciate the suggestion

what

sql prompt is built into visual studio

you knob

@bbaird Aaahh... Lego - the days of innocence before I knew what girls were...

marketplace.visualstudio.com/…

time for coffee and then getting ready for our company Curling event

Coffee secured. Good morning.

> Free Trial

oh wait

marketplace.visualstudio.com/….

@ErikDarling How well does the Format SQL work in that / do you ever use it?

@J.D. it gets me about 80% of the way there

Cool, good to know. Might be helpful for cleaning up a ton of legacy code on my end. Are there options to how it formats?

tons yeah

👍 sweet thanks

there's some weird stuff that it's missing

like adding parens to top expressions

and uh

some of the CTE and CASE formatting leaves a bit to be desired

oOo good to know.