ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Random Thread - Anything Goes

    Water Closet
    time waster cat pics
    141
    21.5k
    9.6m
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • scottalanmillerS
      scottalanmiller
      last edited by

      https://images.i.thechive.com/__8f6987b667c8c1f65adb9c23672bd494_width-600.jpeg

      1 Reply Last reply Reply Quote 0
      • scottalanmillerS
        scottalanmiller
        last edited by

        https://images.i.thechive.com/__a1618f5f0cdf5dea3d70b4ab2916c389_width-600.jpeg

        1 Reply Last reply Reply Quote 0
        • JaredBuschJ
          JaredBusch @JaredBusch
          last edited by 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...

          0_1542121551535_f2656782-c6fd-496c-9091-1da13a90153f-image.png

          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.

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

          tonyshowoffT 1 Reply Last reply Reply Quote 0
          • tonyshowoffT
            tonyshowoff @JaredBusch
            last edited by

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

            0_1542121551535_f2656782-c6fd-496c-9091-1da13a90153f-image.png

            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.

            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

            JaredBuschJ 1 Reply Last reply Reply Quote 0
            • JaredBuschJ
              JaredBusch @tonyshowoff
              last edited by

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

              0_1542121551535_f2656782-c6fd-496c-9091-1da13a90153f-image.png

              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.

              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.

              tonyshowoffT 1 Reply Last reply Reply Quote 0
              • tonyshowoffT
                tonyshowoff @JaredBusch
                last edited by 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...

                0_1542121551535_f2656782-c6fd-496c-9091-1da13a90153f-image.png

                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.

                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.

                1 Reply Last reply Reply Quote 0
                • scottalanmillerS
                  scottalanmiller
                  last edited by

                  0_1542892791641_367a6177755849ab2dd40d03f94f864e--thanksgiving-quotes-funny-happy-thanksgiving.jpg

                  1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller
                    last edited by

                    0_1542900306540_photo6029312839048603767.jpg

                    1 Reply Last reply Reply Quote 1
                    • hobbit666H
                      hobbit666
                      last edited by

                      0_1542988022557_46525809_2329343760473318_5229485341328539648_n.jpg

                      1 Reply Last reply Reply Quote 2
                      • NerdyDadN
                        NerdyDad
                        last edited by

                        0_1543181058468_FB_IMG_1543180973331.jpg

                        ObsolesceO 1 Reply Last reply Reply Quote 1
                        • ObsolesceO
                          Obsolesce @NerdyDad
                          last edited by

                          @NerdyDad said in Random Thread - Anything Goes:

                          0_1543181058468_FB_IMG_1543180973331.jpg

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

                          travisdh1T 1 Reply Last reply Reply Quote 1
                          • travisdh1T
                            travisdh1 @Obsolesce
                            last edited by

                            @Obsolesce said in Random Thread - Anything Goes:

                            @NerdyDad said in Random Thread - Anything Goes:

                            0_1543181058468_FB_IMG_1543180973331.jpg

                            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.

                            jmooreJ 1 Reply Last reply Reply Quote 1
                            • jmooreJ
                              jmoore @travisdh1
                              last edited by

                              @travisdh1 thats first year calculus. Its just an integral

                              travisdh1T 1 Reply Last reply Reply Quote 0
                              • travisdh1T
                                travisdh1 @jmoore
                                last edited by

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

                                DashrenderD scottalanmillerS 2 Replies Last reply Reply Quote 0
                                • DashrenderD
                                  Dashrender @travisdh1
                                  last edited by

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

                                  scottalanmillerS 1 Reply Last reply Reply Quote 1
                                  • scottalanmillerS
                                    scottalanmiller @travisdh1
                                    last edited by

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

                                    1 Reply Last reply Reply Quote 0
                                    • scottalanmillerS
                                      scottalanmiller @Dashrender
                                      last edited by

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

                                      DashrenderD 1 Reply Last reply Reply Quote 0
                                      • hobbit666H
                                        hobbit666
                                        last edited by

                                        0_1543270484855_FB_IMG_1543257927208.jpg

                                        1 Reply Last reply Reply Quote 1
                                        • DashrenderD
                                          Dashrender @scottalanmiller
                                          last edited by

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

                                          1 Reply Last reply Reply Quote 1
                                          • scottalanmillerS
                                            scottalanmiller
                                            last edited by

                                            https://thechive.files.wordpress.com/2018/11/ee4c44126e270057bb3c8c28fb50d057wtmk.jpg?quality=85&strip=info&w=600

                                            1 Reply Last reply Reply Quote 2
                                            • 1
                                            • 2
                                            • 775
                                            • 776
                                            • 777
                                            • 778
                                            • 779
                                            • 1077
                                            • 1078
                                            • 777 / 1078
                                            • First post
                                              Last post