Random Thread - Anything Goes

JaredBusch

@JaredBusch said in Random Thread - Anything Goes:

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

Now working my way column by column to make shit correct..

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.

So, done. I have the data in my local test system.. OMG what a pain in the ass.

Oh and now, I cannot just dump the data and import it to their host, because SQL Server isn't designed for that........

tonyshowoff

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:
@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....

Now working my way column by column to make shit correct..

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.
So, done. I have the data in my local test system.. OMG what a pain in the ass.

Oh and now, I cannot just dump the data and import it to their host, because SQL Server isn't designed for that........

Whenever I have to deal with insane escaping or anything like that in generated SQL, I just convert the value to binary, so:

O'm"
lol

0x4f276d220a6c6f6c

JaredBusch

@tonyshowoff said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:
@JaredBusch said in Random Thread - Anything Goes:
@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....

Now working my way column by column to make shit correct..

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.
So, done. I have the data in my local test system.. OMG what a pain in the ass.

Oh and now, I cannot just dump the data and import it to their host, because SQL Server isn't designed for that........
Whenever I have to deal with insane escaping or anything like that in generated SQL, I just convert the value to binary, so:
O'm"
lol
0x4f276d220a6c6f6c

I didnn't design the database structure. I'm just working with it.

tonyshowoff

@JaredBusch said in Random Thread - Anything Goes:

@tonyshowoff said in Random Thread - Anything Goes:
@JaredBusch said in Random Thread - Anything Goes:
@JaredBusch said in Random Thread - Anything Goes:
@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....

Now working my way column by column to make shit correct..

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.
So, done. I have the data in my local test system.. OMG what a pain in the ass.

Oh and now, I cannot just dump the data and import it to their host, because SQL Server isn't designed for that........
Whenever I have to deal with insane escaping or anything like that in generated SQL, I just convert the value to binary, so:
O'm"
lol
0x4f276d220a6c6f6c
I didnn't design the database structure. I'm just working with it.

The structure doesn't matter, if you're pulling out the data from a CSV, you just create a hex string (make sure you start with 0x) of it so you don't have to worry about escaping new lines, quotes, and the few other characters needed.

scottalanmiller

scottalanmiller

hobbit666

NerdyDad

Obsolesce

@NerdyDad said in Random Thread - Anything Goes:

I'd just answer yes, and leave the math for bots. Or is that the joke?

travisdh1

@Obsolesce said in Random Thread - Anything Goes:

@NerdyDad said in Random Thread - Anything Goes:

I'd just answer yes, and leave the math for bots. Or is that the joke?

If you answer correctly, you are either a bot or theoretical mathematician. Either way, not quite human.

jmoore

@travisdh1 thats first year calculus. Its just an integral

travisdh1

@jmoore said in Random Thread - Anything Goes:

@travisdh1 thats first year calculus. Its just an integral

I don't remember doing anything quite that involved, but I only ever got to pre-calculus in math.

Dashrender

@travisdh1 said in Random Thread - Anything Goes:

@jmoore said in Random Thread - Anything Goes:

@travisdh1 thats first year calculus. Its just an integral

I don't remember doing anything quite that involved, but I only ever got to pre-calculus in math.

The integral is the most complex thing in there - not that I recall how to do cos/log anymore - I think I had to look on a chart if memory serves.

scottalanmiller

@travisdh1 said in Random Thread - Anything Goes:

@jmoore said in Random Thread - Anything Goes:

@travisdh1 thats first year calculus. Its just an integral

I don't remember doing anything quite that involved, but I only ever got to pre-calculus in math.

Pre-Calc definitely doesn't cover any calc, lol.

scottalanmiller

@Dashrender said in Random Thread - Anything Goes:

@travisdh1 said in Random Thread - Anything Goes:

@jmoore said in Random Thread - Anything Goes:

@travisdh1 thats first year calculus. Its just an integral

I don't remember doing anything quite that involved, but I only ever got to pre-calculus in math.

The integral is the most complex thing in there - not that I recall how to do cos/log anymore - I think I had to look on a chart if memory serves.

I always found integrals easier than cos/sin.

hobbit666

Dashrender

@scottalanmiller said in Random Thread - Anything Goes:

@Dashrender said in Random Thread - Anything Goes:

@travisdh1 said in Random Thread - Anything Goes:

@jmoore said in Random Thread - Anything Goes:

@travisdh1 thats first year calculus. Its just an integral

I don't remember doing anything quite that involved, but I only ever got to pre-calculus in math.

The integral is the most complex thing in there - not that I recall how to do cos/log anymore - I think I had to look on a chart if memory serves.

I always found integrals easier than cos/sin.

agreed! Trig was murder for me.

scottalanmiller