| 05:43.11 | *** join/#asterisk-doc oej (n=olle@ns.webway.se) |
| 07:24.08 | *** join/#asterisk-doc oej (n=olle@ns.webway.se) |
| 10:45.49 | *** join/#asterisk-doc russellb (n=russellb@asterisk/digium-open-source-team-lead/russellb) [NETSPLIT VICTIM] |
| 12:45.00 | *** join/#asterisk-doc Shazaum (n=aaaaaaaa@unaffiliated/shazaum) |
| 12:45.06 | Shazaum | hi |
| 13:06.50 | *** join/#asterisk-doc Alric (n=nbowyer@appliance.1stel.com) |
| 14:25.41 | *** join/#asterisk-doc leifmadsen (n=chatzill@asterisk/documenteur-extraordinaire/blitzrage) |
| 14:25.41 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 14:29.08 | *** join/#asterisk-doc eliel (n=eliels@200.61.172.61) |
| 14:40.10 | *** join/#asterisk-doc russell (n=russell@nat/digium/x-iqruvkknbjknvrhj) |
| 15:00.18 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 15:00.18 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 15:15.32 | *** join/#asterisk-doc oej (n=olle@ns.webway.se) [NETSPLIT VICTIM] |
| 15:15.32 | *** join/#asterisk-doc DarkFlibb (n=DarkFlib@cpc3-nfds13-2-0-cust424.8-2.cable.virginmedia.com) [NETSPLIT VICTIM] |
| 15:15.32 | *** join/#asterisk-doc snuff-home (n=snuffy@203-219-29-182-bri-ts6-2600.tpgi.com.au) [NETSPLIT VICTIM] |
| 15:17.59 | *** join/#asterisk-doc snuff-home2 (n=snuffy@203-219-29-182-bri-ts6-2600.tpgi.com.au) |
| 16:01.06 | *** join/#asterisk-doc oej (n=olle@87.96.134.125) |
| 16:04.17 | ctooley | Ann and I were talking and we finally decided on a date for getting married. |
| 16:04.49 | Alric | Congratulations |
| 16:09.21 | seanbright | ctooley: didn't you just get divorced? |
| 16:09.37 | ctooley | seanbright, A month ago yesterday |
| 16:10.41 | seanbright | ctooley: you work quick! :-) |
| 16:11.14 | ctooley | seanbright, eh, divorce took a long time anyway. |
| 16:11.19 | seanbright | ah |
| 16:11.47 | ctooley | Ann and I are sort of fast tracking the process a bit, but seeing as the baby is due on Christmas Day, it's not too bad. |
| 16:11.59 | seanbright | well very nice |
| 16:12.00 | seanbright | congrats |
| 16:15.35 | *** join/#asterisk-doc russellb (n=russellb@asterisk/digium-open-source-team-lead/russellb) |
| 16:16.19 | *** join/#asterisk-doc MuffinMan (n=muffinma@asterisk/issue-tracker-bot/muffinman) |
| 17:11.04 | Juggie | ping |
| 17:11.08 | Alric | pong |
| 17:11.45 | Juggie | anyone ever join a table to itself for the purpose of stats, eg lets say you have June01-31 2008 and you want to join it to compare to June01-31 2009 |
| 17:11.54 | Juggie | its being difficult :) |
| 17:15.22 | Alric | joining tables to themselves is black magic |
| 17:15.34 | Juggie | indeed |
| 17:15.46 | Juggie | to get it to work the previous developer did two full joins w/ a union |
| 17:16.04 | Juggie | i would like to dump the union but i cant seem to get the full outer join to work properly. |
| 17:39.52 | leifmadsen | eep! |
| 18:14.17 | seanbright | Juggie: you have some code? |
| 18:14.26 | seanbright | or is it too late? |
| 18:39.41 | Juggie | i've got something working now |
| 18:39.59 | Juggie | i ended up doing a each table in a sub select and then did the join in the outer select |
| 18:40.02 | Juggie | that seems to work much better |
| 18:48.46 | seanbright | joining a table on itself isn't that big of a deal, you just have to alias the tables properly |
| 18:48.50 | seanbright | i've never had an issue |
| 18:48.54 | seanbright | just for future reference. |
| 18:49.38 | Juggie | well its kidn of a weird join because i need it to be a full outer and its joined dates but the dates are 2-3 days fof |
| 18:49.39 | Juggie | *off |
| 18:49.55 | seanbright | gotcha |
| 18:50.31 | Juggie | so for example if i'm missing a piece of data for any given day it wont prohibit the data for the date i'm comparing to being shown, etc. |
| 19:04.53 | *** join/#asterisk-doc oej (n=olle@ns.webway.se) |