Random Thread - Anything Goes

NashBrydges

@RojoLoco LMAO! Genius marketing and shelf product placement.

RojoLoco

@NashBrydges said in Random Thread - Anything Goes:

@RojoLoco LMAO! Genius marketing and shelf product placement.

Right? I wish I had been that clever when I worked in retail.

DustinB3403

It's still a trick, that price isn't per diaper its for a box of 100.

NashBrydges

@DustinB3403 said in Random Thread - Anything Goes:

It's still a trick, that price isn't per diaper its for a box of 100.

Other way to look at it...

12 condoms = 2 weeks to 1 month worth of product (ymmv)
100 diapers = you're set for 3-5 days based on how much your baby goes through them

RojoLoco

@NashBrydges 12 condoms = 2 good nights or 1 great one.

nadnerB

nadnerB

I'd pay money to see this.
0_1542342739706_8078c0e4-af28-4737-9570-dd2e5b98be02-image.png

dafyre

NerdyDad

nadnerB

@NerdyDad said in Random Thread - Anything Goes:

Those people need clippy...
0_1542534662722_8C307DA3-4814-4E03-8ED9-9E4A7435866A.jpeg

DustinB3403

How fast Santa goes to hit everyone's house in a night..

650 miles per second

From The Physics of Santa Claus ()

"Santa has 31 hours of Christmas to work with, thanks to the different time zones and the rotation of the earth, assuming he travels east to west(which seems logical). This works out to 822.6 visits per second. This is to say that for each Christian household with good children, Santa has 1/1000th of a second to park, hop out of the sleigh, jump down the chimney, fill the stockings, distribute the remaining presents under the tree, eat whatever snacks have been left, get back up the chimney, get back into the sleigh and move on to the next house. Assuming that each of these 91.8 million stops are evenly distributed around the earth (which, of course, we know to be false but for the purposes of our calculations we will accept), we are now talking about .78 miles per household, a total trip of 75-1/2 million miles, not counting stops to do what most of us must do at least once every 31 hours, plus feeding etc.
This means that Santa's sleigh is moving at 650 miles per second, 3,000 times the speed of sound. For purposes of comparison, the fastest man- made vehicle on earth, the Ulysses space probe, moves at a poky 27.4 miles per second - a conventional reindeer can run, tops, 15 miles per hour."

JaredBusch

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

Microsoft can kiss my fucking ass.

SQL, Excel, Access, all of it.

This keeps getting up votes.. so for reference...

So the workaround... I manually created a table with all the columns in the spreadsheet using datatype NVARCHAR(255) for every column.

I opened the spreadhseet in LibreOffice Calc.

Saved the sheet as a csv, chosing the | for my delimiter because it does not exist in the file.

Then some find/replace magic in VSCode.

' -> ''
" -> ""
\n -> ');\n
| -> ','
^ -> INSERT INTO NETL_Import (columns listed) value ('

Saved as NETL_Import.sql and ran it in Azure Data Studio.

12328 rows imported later, I now have to clean all that shit up into real data types.

Figured out a bunch of easy cleanup....
0_1542692739731_0ddb6ca8-5105-4e79-a8fa-6d01f0f525c3-image.png

Now working my way column by column to make shit correct..
0_1542692799348_56ef5bcc-044c-4719-a863-1a07ffd00601-image.png

But it will be correct, and it will be a repeatable script. Because there is no way in hell that we've been told everything correctly.

JaredBusch

The block comments around the updates are just so I do not run them every time I rerun the insert as I work down each column. The top of the entire file starts with a truncate to I can jsut keep rerunning things adding columns of data.