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.sqland 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........
-
@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.sqland 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" lol0x4f276d220a6c6f6c
-
@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.sqland 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" lol0x4f276d220a6c6f6c
I didnn't design the database structure. I'm just working with it.
-
@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.sqland 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" lol0x4f276d220a6c6f6c
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.
-
-
-
-
-
@NerdyDad said in Random Thread - Anything Goes:
I'd just answer yes, and leave the math for bots. Or is that the joke?
-
@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.
-
@travisdh1 thats first year calculus. Its just an integral
-
@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.
-
@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.
-
@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.
-
@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.
-
-
@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.
-
-
-
