| --- Log opened Fri Apr 22 00:00:38 2016 |
| 00:56 | | thalass [thalass@Nightstar-283.o7s.158.104.IP] has joined #code |
| 00:56 | | mode/#code [+o thalass] by ChanServ |
| 01:00 | | Derakon[AFK] is now known as Derakon |
| 01:02 | | thalass is now known as Thalass|actuallyTF2 |
| 01:43 | | Turaiel[Offline] is now known as Turaiel |
| 01:47 | | * Vornicus tries to figure out if he can enumerate permutations in Excel. |
| 01:50 | | * Vornicus breaks out the Knuth for the first time in a while. |
| 02:01 | | * Vornicus determines his memory of the permutation algorithm is accurate despite doubts |
| 02:14 | | Thalass|actuallyTF2 is now known as Thalass |
| 02:26 | <~Vornicus> | need a whole bunch of auxliaries, looks like |
| 02:40 | <@Reiv> | Someone help me with the logic of SQL here |
| 02:40 | <@Reiv> | Don't panic about the exact functions, just the, uh, braining bit |
| 02:41 | <@Reiv> | I need to report only on the current financial year (which for us starts on April 1st, which entirely ruins april fools I'll tell ya) |
| 02:41 | <@Reiv> | this isn't too hard, I can take the relevant date column and turn it into an FY with 'new years' of April1st |
| 02:41 | <@Reiv> | The problem and headache |
| 02:41 | <@Reiv> | This is a montly report |
| 02:42 | <@Reiv> | Theoretically run only on the 1st, or as close to the 1st as possible |
| 02:42 | <@Reiv> | And for the month of April it needs to report on /the prior year/ |
| 02:42 | <@Reiv> | Fenceposts hooray |
| 02:43 | <@Reiv> | Come May, you want to report on April. All the way till the end of March. But in April, you still need to capture March's numbers, and those of the entire FY... despite it technically being the next one, which you /don't/ want to look at just yet. |
| 02:44 | <@Reiv> | It is maketh my head explode just how to articulate this ;_; |
| 02:45 | <@Reiv> | Vornicus, McMartin: You might not know the actual SQL bits per se, but can you help me nut out the problem in my head? |
| 02:45 | <@Reiv> | I have all the logical operators you'd expect, and full date resolution to the year, month, and day components individually as needed |
| 02:46 | <~Vornicus> | Okay I'm a little confused. |
| 02:46 | <~Vornicus> | I run the report on May 1 2016, I get data from April 1 2015 to March 31 2016? |
| 02:47 | <@Reiv> | Er, May is a terrible example, but I guess it's needed |
| 02:47 | <~Vornicus> | Wait, no, I see what you're up to. Different data |
| 02:47 | <@Reiv> | Run report May 1 2016, and you will get everything from April 1 2016 |
| 02:48 | <@Reiv> | I run the report April 1 2016, I get everything from April 1 2015 |
| 02:48 | <@Reiv> | This is because the report runs monthly for monthly updates, but is retroactive |
| 02:48 | <~Vornicus> | Okay: 1. if you report on May 1, you want April 1 2016 to now. 2. if it's April still, get the data from April 1 2015 to March 31 2016. |
| 02:48 | <@Reiv> | Or well, it /was/ completely retroactive in catching any retroactive records, and now someone tells me that we can't do it across FY boundaries~ |
| 02:49 | <@Reiv> | 1. Correct |
| 02:49 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 02:54 | <@Reiv> | hm |
| 02:54 | <@Reiv> | I guess I could... eh, no, that's a pain in the butt too |
| 02:54 | <@Reiv> | Or is it, hm |
| 02:54 | <~Vornicus> | what? |
| 02:54 | <@Reiv> | I had an idea, but simply subtracting everything back one month means everything is bad and wrong in may instead, so let's not do tat |
| 02:55 | <@Reiv> | Any thoughts vorn? |
| 02:56 | <@Reiv> | I guess I just need a special-case line in there |
| 02:57 | <@Reiv> | WHERE SpentFY = CurrentFY OR (Month(sysdate) = 4 AND SpentFY = CurrentFY - 1) |
| 02:58 | <@Reiv> | Shit no that still grabs 2016-04-12 and fits it into FY 2015 stuff |
| 02:58 | <@Reiv> | I don't need an OR, I need an esca-- |
| 02:58 | <@Reiv> | CASE statements are single-execution |
| 02:58 | <@Reiv> | HA |
| 02:59 | <~Vornicus> | heh |
| 03:00 | <@Reiv> | WHERE (CASE WHEN month(sysdate) = 4 AND SpentFY = CurrentFY -1 THEN 1 WHEN SpentFY = CurrentFY THEN 1 ELSE 0) = 1 |
| 03:01 | <@Reiv> | CASE statements exit after the first line to satisfy the WHEN clause |
| 03:02 | <@Reiv> | This can result in great fun when you actually want it to not do that, but in places like this can be handy for mutually exclusive bits of logic |
| 03:02 | <@Reiv> | Does that parse to a humans eyes, Vorn? |
| 03:02 | <@Reiv> | 'cuz if so I then get to go make that into one hella chuthulian bit of SQL >_> |
| 03:03 | <~Vornicus> | okay |
| 03:03 | <~Vornicus> | looks vaguely sensible |
| 03:04 | <@Reiv> | It's saying that if it's april, subtract 1 from FY |
| 03:04 | <@Reiv> | Else run on current FY |
| 03:04 | <@Reiv> | Right? |
| 03:05 | <@Reiv> | I mean this'd be if-then-else statements in any saner language |
| 03:05 | <@Reiv> | (Though I confess, the CASE statements leave me weeping when I try to work in a language where they /don't/ exist) |
| 03:07 | <~Vornicus> | I am having a hard time telling actually. |
| 03:08 | <@Reiv> | Psuedocode too literal? |
| 03:08 | <~Vornicus> | It's -- there's things like -- what is spentfy and currentfy |
| 03:08 | <@Reiv> | Oh! |
| 03:08 | <@Reiv> | Financial Year something was spent in |
| 03:08 | <@Reiv> | Current Financial Year (aka modified sysdate) |
| 03:09 | <~Vornicus> | Okay there's more information here than I thought we were dealing with. |
| 03:09 | <~Vornicus> | --wait, is spentfy by-row? |
| 03:09 | <@Reiv> | Yep |
| 03:10 | <~Vornicus> | aha |
| 03:10 | <~Vornicus> | okay makes sense now |
| 03:10 | <@Reiv> | Sorry! |
| 03:10 | | * Reiv goes and writes up the conversion between SpentAt date and SpentFY into the view he's using, so that it's out of the way. |
| 03:19 | | himi [fow035@Nightstar-5c1rrp.bigpond.net.au] has joined #code |
| 03:19 | | mode/#code [+o himi] by ChanServ |
| 03:25 | | * Reiv snickers, throws the CurrentFY onto every single row on the table too, just to save space in his code. |
| 03:36 | <~Vornicus> | tis might be a comp.sci y problem: I have a shopping list and a set of stores, which all carry different (but not necessarily disjoint) sets of products. I wish to minimize the number of stores I must go to to do all my shopping (product prices, gas, etc, do not matter). Does this problem have a name? |
| 03:43 | <@Reiv> | oop, no, that doesn't work |
| 03:44 | <@Reiv> | I think I need an extra ELSE in there somewhere |
| 03:44 | | * Reiv muses |
| 03:44 | <@Reiv> | It's capturing both last year and this year, because of course it is, there's two lines |
| 03:44 | <@Reiv> | Oh |
| 03:44 | <@Reiv> | 'WHEN month(sysdate) = 4' is on one line |
| 03:45 | <@Reiv> | It might behoove me to have 'WHEN month(sysdate) <> 4' on the other one~ |
| 03:45 | <@Reiv> | Thank you, #Code, for being my rubber duck >_> |
| 03:45 | | * Reiv goes back to typing. In QWERTY. ugh, stupid remote servers. |
| 03:47 | < RobinStamer> | Your terminal emulator sends the keycodes? |
| 03:56 | <@Reiv> | Remote desktop |
| 03:56 | <@Reiv> | We're a windows shop |
| 03:56 | <@Reiv> | And the machine I'm logged into does not know what DVORAK is~ |
| 03:57 | < RobinStamer> | Doesn't Windows support SSH now? |
| 03:58 | < RobinStamer> | No reason to run a full GUI to run SQL queries, is there? |
| 03:58 | <@Reiv> | Oh, it's /much/ funnier than that |
| 03:59 | <@Reiv> | I am using Checkpoint to get onto the corporate VPN, which then allows me to login to a remote machine that would otherwise be off limits |
| 03:59 | < RobinStamer> | That's relatively normal. |
| 03:59 | <@Reiv> | I am then using SQL Server on that machine to run my code 'locally', because we set up our DB systems to refuse to accept VPN connections ^.^ |
| 03:59 | <@Reiv> | (;_;) |
| 04:00 | <@Reiv> | I have the IDE right here with the code on it |
| 04:00 | <@Reiv> | But I'm not allowed to use it :p |
| 04:00 | < RobinStamer> | Eh, I've had to deal with worse. |
| 04:01 | <@Reiv> | Oh, this isn't a misery-peen competition |
| 04:01 | <@Reiv> | But you're providing helpful suggestions on why I shouldn't even need a GUI to run my code |
| 04:01 | <@Reiv> | So I figured I might as well point out the daisy-chain of Lame I've had to go through to run the code at all |
| 04:02 | <@Reiv> | Best part? The servers are cloud-hosted. We can only see them at all because they're part of a corporate VPN. |
| 04:02 | <@Reiv> | The same one that is refusing to let me on them. hooray security, eh? :p |
| 04:03 | < RobinStamer> | VPN to client side (said software was a massive cluster fuck). Citrix into a Windows NT machine, which automatically RDP'd into a Windows XP machine. Then use a ... can't remember the name of it. The LDAP thing Windows used before Active Directory was a serious thing. Eitherway, admin client of that to connect to the LDAP network so we could... reset passwords. |
| 04:03 | < RobinStamer> | If we were working remotely... add another VPN jump to all that. |
| 04:04 | <@Reiv> | Yep |
| 04:04 | < RobinStamer> | (Note: everyone ended up RDPing into the same XP machine... which means only one person could have the PW reset tool open at a time) |
| 04:05 | < RobinStamer> | This was all in 2009ish BTW. |
| 04:06 | <@Reiv> | This is 2016 |
| 04:06 | <@Reiv> | I didn't have to daisy-chain at all until we went cloud-based. |
| 04:08 | | Thalass [thalass@Nightstar-283.o7s.158.104.IP] has quit [[NS] Quit: aaaaughflop] |
| 04:19 | | macdjord [macdjord@Nightstar-r9vt2h.mc.videotron.ca] has joined #code |
| 04:19 | | mode/#code [+o macdjord] by ChanServ |
| 04:19 | | jerith [jerith@Nightstar-ip7ar2.slipgate.net] has quit [Operation timed out] |
| 04:22 | | jerith [jerith@Nightstar-ip7ar2.slipgate.net] has joined #code |
| 04:22 | | mode/#code [+ao jerith jerith] by ChanServ |
| 04:23 | | Kindamoody[zZz] is now known as Kindamoody |
| 05:08 | | Derakon is now known as Derakon[AFK] |
| 05:40 | | himi [fow035@Nightstar-5c1rrp.bigpond.net.au] has quit [Ping timeout: 121 seconds] |
| 06:32 | | Turaiel is now known as Turaiel[Offline] |
| 07:16 | | * Vornicus almost almost has the cultists moving in vorns ahoy, finally |
| 07:35 | <&McMartin> | I forget. Are the cultists the !ducks? |
| 07:36 | <&McMartin> | I assume Great Cthulhu will be the !hippo |
| 07:38 | <~Vornicus> | Precisely |
| 07:40 | <@Reiv> | you eat the cultists, right? |
| 07:42 | <&McMartin> | I would imagine you deliver them to their proper altars |
| 07:42 | <~Vornicus> | in vorns ahoy you're a gondola that picks up cultists and takes them to the !beach |
| 07:42 | <~Vornicus> | While avoiding crashing into Great Cthulhu's head. |
| 07:47 | | * Vornicus did it! |
| 08:05 | | catadroid [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [[NS] Quit: Bye] |
| 08:14 | | Kindamoody is now known as Kindamoody|afk |
| 08:14 | <~Vornicus> | http://imgur.com/7Nta4Y2 |
| 08:17 | <~Vornicus> | (excuse the encoding errors) |
| 08:25 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has joined #code |
| 08:25 | | mode/#code [+o himi] by ChanServ |
| 08:37 | | ion_ [Owner@Nightstar-6grqph.vs.shawcable.net] has joined #code |
| 08:39 | | ion [Owner@Nightstar-6grqph.vs.shawcable.net] has quit [Ping timeout: 121 seconds] |
| 08:43 | | mac [macdjord@Nightstar-r9vt2h.mc.videotron.ca] has joined #code |
| 08:43 | | mode/#code [+o mac] by ChanServ |
| 08:45 | | macdjord [macdjord@Nightstar-r9vt2h.mc.videotron.ca] has quit [Ping timeout: 121 seconds] |
| 09:29 | | macdjord [macdjord@Nightstar-r9vt2h.mc.videotron.ca] has joined #code |
| 09:29 | | mode/#code [+o macdjord] by ChanServ |
| 09:30 | | mac [macdjord@Nightstar-r9vt2h.mc.videotron.ca] has quit [Ping timeout: 121 seconds] |
| 10:44 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 10:56 | | Crossfire [Z@Nightstar-3nmkps.tpgi.com.au] has joined #code |
| 10:56 | | mode/#code [+o Crossfire] by ChanServ |
| 11:32 | | catadroid [catalyst@Nightstar-ruq2qh.dab.02.net] has joined #code |
| 11:49 | | Emmy-zZz is now known as Emmy |
| 12:29 | | catadroid` [catalyst@Nightstar-ufbnsf.dab.02.net] has joined #code |
| 12:32 | | catadroid [catalyst@Nightstar-ruq2qh.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 13:10 | | Gnomino [Gnomino@Nightstar-7a0.1v2.174.90.IP] has joined #code |
| 13:11 | | Gnomino [Gnomino@Nightstar-7a0.1v2.174.90.IP] has quit [[NS] Quit: Bye] |
| 13:12 | | Crossfire [Z@Nightstar-3nmkps.tpgi.com.au] has quit [Ping timeout: 121 seconds] |
| 13:22 | | Crossfire [Z@Nightstar-3nmkps.tpgi.com.au] has joined #code |
| 13:22 | | mode/#code [+o Crossfire] by ChanServ |
| 13:39 | | Reiv_ [NSwebIRC@Nightstar-g7fs0k.xtra.co.nz] has joined #code |
| 13:40 | | Reiv [NSwebIRC@Nightstar-g7fs0k.xtra.co.nz] has quit [Ping timeout: 121 seconds] |
| 14:43 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud, @ToxicFrog |
| 14:45 | | Netsplit over, joins: @PinkFreud, &ToxicFrog |
| 14:47 | | Netsplit Kakrafoon.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud, @ToxicFrog |
| 14:51 | | Netsplit over, joins: @PinkFreud |
| 14:53 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has joined #code |
| 14:53 | | mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ |
| 16:48 | | Emmy [M@Nightstar-9p7hb1.direct-adsl.nl] has quit [Connection closed] |
| 17:02 | | catadroid` is now known as catadroid |
| 17:15 | | JustBob [justbob@Nightstar.Customer.Dissatisfaction.Administrator] has quit [Connection reset by peer] |
| 18:10 | | Derakon[AFK] [chriswei@Nightstar-5mvs4e.ca.comcast.net] has quit [Connection closed] |
| 18:11 | | Netsplit Kakrafoon.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud, @ToxicFrog |
| 18:11 | | Netsplit over, joins: @PinkFreud, &ToxicFrog |
| 18:12 | | Derakon [chriswei@Nightstar-5mvs4e.ca.comcast.net] has joined #code |
| 18:12 | | mode/#code [+ao Derakon Derakon] by ChanServ |
| 18:14 | | McMartin [mcmartin@Nightstar-rpcdbf.sntcca.sbcglobal.net] has quit [Ping timeout: 121 seconds] |
| 18:14 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 18:15 | | McMartin [mcmartin@Nightstar-rpcdbf.sntcca.sbcglobal.net] has joined #code |
| 18:15 | | mode/#code [+ao McMartin McMartin] by ChanServ |
| 18:22 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has joined #code |
| 18:22 | | mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ |
| 18:27 | < Attilla> | is it possible to use a driver or something to turn a headphone port into a combination headphone/microphone port or is this some impossible dream (is there a functional physical difference between single mic/headphone ports and separate ones?) |
| 18:31 | < crystalclaw> | Yeah, combined ports have four contacts inside, where normal headphone ports have only 3 |
| 18:31 | < Attilla> | ah, okay! |
| 18:31 | < Attilla> | i guess the answer will be a splitter then |
| 18:32 | < crystalclaw> | That'd be best |
| 18:42 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 18:46 | | gizmore [kvirc@Nightstar-pfbu9i.dip0.t-ipconnect.de] has joined #code |
| 18:55 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 18:55 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 18:59 | | Crossfire [Z@Nightstar-3nmkps.tpgi.com.au] has quit [Ping timeout: 121 seconds] |
| 18:59 | | catadroid` [catalyst@Nightstar-11dd23.dab.02.net] has joined #code |
| 19:00 | | catadroid [catalyst@Nightstar-ufbnsf.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 19:13 | | Kindamoody|afk is now known as Kindamoody |
| 20:59 | | gizmore [kvirc@Nightstar-pfbu9i.dip0.t-ipconnect.de] has quit [[NS] Quit: KVIrc 4.9.2 Aria http://www.kvirc.net/] |
| 21:01 | | JustBob [justbob@ServerAdministrator.Nightstar.Net] has joined #code |
| 21:01 | | mode/#code [+o JustBob] by ChanServ |
| 21:08 | | catadroid` [catalyst@Nightstar-11dd23.dab.02.net] has quit [[NS] Quit: Bye] |
| 21:40 | | Kindamoody is now known as Kindamoody[zZz] |
| 23:34 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [[NS] Quit: Leaving] |
| 23:35 | | crystalclaw is now known as crystalclaw|AFK |
| 23:41 | | catadroid [catalyst@Nightstar-11dd23.dab.02.net] has joined #code |
| --- Log closed Sat Apr 23 00:00:54 2016 |