| 00:03.56 | *** join/#utah pashdown (pashdown@sine.xmission.com) |
| 00:30.15 | *** part/#utah contempt (~boh@host241-156-dynamic.21-79-r.retail.telecomitalia.it) |
| 00:49.30 | sontek | goozbach: tmux!! |
| 00:49.39 | goozbach | screen! |
| 00:51.29 | sontek | >:| |
| 00:51.33 | sontek | tmux > screen |
| 00:51.54 | goozbach | tmux is complicated! |
| 01:02.24 | *** join/#utah bmidgley_ (~brad@c-76-27-89-77.hsd1.ut.comcast.net) |
| 01:07.58 | eightyeight | screen > tmux |
| 01:08.05 | eightyeight | let the holy war commence! |
| 01:08.27 | *** join/#utah pelaofeliz (~pelaofeli@67.137.236.66) |
| 01:08.38 | goozbach | both are awesome |
| 01:08.46 | goozbach | and.... it fizzles |
| 01:08.55 | eightyeight | party pooper |
| 01:17.41 | *** join/#utah tarrant (~tarrant@69.169.141.202.provo.static.broadweavenetworks.net) |
| 01:18.24 | *** join/#utah tarrant (~tarrant@216.83.139.130) |
| 01:21.49 | *** join/#utah tarrant (~tarrant@69.169.141.202.provo.static.broadweavenetworks.net) |
| 01:47.02 | *** join/#utah mabes (~mabes@runner.fttp.xmission.com) |
| 02:16.18 | *** join/#utah prank (hoax@ninja.hacked.jp) |
| 02:28.38 | *** join/#utah tiwula (~lane@63.225.228.210) |
| 03:05.00 | *** join/#utah macnewbold (~Adium@c-98-202-75-24.hsd1.ut.comcast.net) |
| 03:56.45 | *** join/#utah har-od (~dshipp@c-71-195-218-161.hsd1.ut.comcast.net) |
| 04:51.11 | *** join/#utah carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 04:52.09 | *** join/#utah jalbretsen (~jalbretse@c-76-27-51-43.hsd1.ut.comcast.net) |
| 04:55.04 | *** join/#utah har-od (~dshipp@c-71-195-218-161.hsd1.ut.comcast.net) |
| 04:55.48 | *** join/#utah vontrapp (~vontrapp@50.8.106.170) |
| 04:55.48 | ibot | cowers |
| 04:56.27 | vontrapp | hey SQL peeps. table a and table b, joined on a.foo=b.foo |
| 04:56.58 | vontrapp | but if a.foo exists (foo=1) but b.foo does not (no foo=1) i want a null entry |
| 04:57.07 | vontrapp | I know there's a way to do this, but I can't remember it |
| 04:57.18 | vontrapp | null where b would be, that is |
| 05:00.54 | vontrapp | but, more particularly, i want a.id, count(b.id) |
| 05:01.19 | vontrapp | one row for each a, and the count of rows in b that match a on whatever criteria |
| 05:07.54 | *** join/#utah mabes (~mabes@runner.fttp.xmission.com) |
| 05:10.51 | vontrapp | hrmm, left join should work |
| 05:12.10 | sontek | yeah, left join will do the trick |
| 05:12.50 | sontek | SELECT a.foo FROM a LEFT JOIN b on a.foo = b.foo |
| 05:13.32 | vontrapp | sontek, that's what i'm doing, and that's what i thought would work and it didn't |
| 05:13.43 | sontek | what was the result? |
| 05:16.30 | vontrapp | aaah, it was my where |
| 05:16.37 | vontrapp | i was selecting on table b |
| 05:16.45 | vontrapp | of course the select would never select NULL |
| 05:16.48 | vontrapp | :p |
| 05:16.58 | vontrapp | moved those statements to the join clause, and now happiness |
| 05:23.24 | sontek | ^_^ |
| 05:42.10 | *** join/#utah themiddleman (~rob@c-67-182-247-76.hsd1.ut.comcast.net) |
| 06:27.55 | *** join/#utah har-od (~dshipp@c-71-195-218-161.hsd1.ut.comcast.net) |
| 07:16.40 | *** join/#utah har-od (~dshipp@c-71-195-218-161.hsd1.ut.comcast.net) |
| 09:59.07 | *** join/#utah zzzirk_away (~zzzirk@173-10-29-145-BusName-utah.ut.hfc.comcastbusiness.net) |
| 13:23.16 | *** join/#utah sshaw (~decriptor@53.250.sfcn.org) |
| 13:43.49 | *** join/#utah redbeard_work (~jphall@fw.oremut02.us.wh.verio.net) |
| 14:05.12 | *** join/#utah emcnabb_ (~emcnabb@cpe-024-211-241-245.nc.res.rr.com) |
| 14:57.33 | *** join/#utah thaddeusq (~thaddeusq@216.49.181.128) |
| 15:09.38 | *** join/#utah mabes (~mabes@runner.fttp.xmission.com) |
| 15:15.23 | *** join/#utah macnewbold (~Adium@66.60.115.30) |
| 15:44.23 | *** join/#utah SunSparc (~sparky@24-104-129.146.hfc.mediarain.com) |
| 15:53.03 | *** join/#utah bmidgley_ (~brad@66.236.74.194.ptr.us.xo.net) |
| 16:02.06 | *** join/#utah fadein (~Erik@c-71-199-16-47.hsd1.ut.comcast.net) |
| 16:14.23 | *** join/#utah fungus (~olsonl@bromine.sosstaffing.com) |
| 16:22.00 | *** join/#utah wps (~wps@76.8.223.101) |
| 16:25.20 | *** join/#utah neybar (~jalance@74-220-196-116.bluehost.com) |
| 16:26.21 | *** join/#utah tiwula (~lane@70.89.246.241-Busname-UT.hfc.comcastbusiness.net) |
| 16:27.02 | *** join/#utah ljenkins (~ljenkins@2001:1948:212::a) |
| 16:29.09 | *** join/#utah mabes (~mabes@66.236.74.194.ptr.us.xo.net) |
| 16:47.40 | *** join/#utah har-od (~dshipp@fw.oremut02.us.wh.verio.net) |
| 16:49.08 | *** join/#utah tarrant (~tarrant@216.83.139.130) |
| 16:51.48 | *** join/#utah jpwhiting (~bip@75-169-200-28.slkc.qwest.net) |
| 16:51.48 | *** join/#utah jpwhiting (~bip@kde/developer/whiting) |
| 17:03.21 | *** join/#utah dharmatech (~hayduke@utriders.dsl.xmission.com) |
| 17:06.08 | *** join/#utah pashdown (pashdown@sine.xmission.com) |
| 17:30.48 | *** part/#utah larrys (~larrys@c-76-27-113-134.hsd1.ut.comcast.net) |
| 17:35.42 | *** join/#utah larrys (~larrys@c-76-27-113-134.hsd1.ut.comcast.net) |
| 17:38.52 | *** join/#utah JessieAMorris (~jessie@nova.caandb.com) |
| 17:40.58 | *** part/#utah macnewbold (~Adium@66.60.115.30) |
| 17:41.01 | *** join/#utah macnewbold (~Adium@66.60.115.30) |
| 17:41.06 | *** part/#utah har-od (~dshipp@fw.oremut02.us.wh.verio.net) |
| 17:42.05 | *** join/#utah Tene (~tene@poipu/supporter/slacker/tene) |
| 18:09.45 | *** join/#utah carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 18:23.35 | *** join/#utah ph4se (~ph4se@205.127.244.62) |
| 18:24.37 | *** join/#utah ph4se (~ph4se@205.127.244.62) |
| 18:25.54 | *** join/#utah ph4se (~ph4se@205.127.244.62) |
| 18:26.00 | *** join/#utah undertakingyou (~will@67.214.250.163) |
| 18:29.38 | *** join/#utah TimRiker (timr@bzflag/projectlead/TimRiker) |
| 18:29.38 | *** mode/#utah [+o TimRiker] by ChanServ |
| 18:29.42 | TimRiker | who |
| 18:29.52 | TimRiker | heh |
| 18:31.18 | goozbach | howdy TimRiker |
| 18:32.37 | TimRiker | heya. :) working at the church now. (again?) |
| 18:34.45 | goozbach | when did that happen? |
| 18:34.57 | goozbach | I vaugely remember seeing that on linkedin |
| 18:35.33 | goozbach | or something |
| 18:35.38 | goozbach | aparently we aren't connected |
| 18:35.41 | goozbach | thought we were |
| 18:36.38 | TimRiker | heh. connect! :) |
| 18:37.14 | goozbach | sent! |
| 18:37.21 | goozbach | wonder where I saw that then... |
| 18:37.31 | TimRiker | didn't update linkedin, etc. still hoping that the vphone will get funded, so not talking about my new gig too much. |
| 18:38.08 | TimRiker | http://www.linkedin.com/in/timriker |
| 19:32.42 | *** join/#utah TimRiker (timr@bzflag/projectlead/TimRiker) |
| 19:32.42 | *** mode/#utah [+o TimRiker] by ChanServ |
| 19:34.14 | *** join/#utah TimRiker (timr@bzflag/projectlead/TimRiker) |
| 19:34.14 | *** mode/#utah [+o TimRiker] by ChanServ |
| 20:04.59 | *** join/#utah vontrapp (~vontrapp@12.191.193.40) |
| 20:04.59 | ibot | cowers |
| 20:08.43 | tristanrhodes_ | wow, 5,000 people are seeding Ubuntu Linux. Does anyone know what is the most seeded torrent? |
| 20:12.15 | JoshH | probably a justin beiber album |
| 20:13.30 | tristanrhodes_ | no, that would be all leachers |
| 20:31.53 | thaddeusq | TimRiker: I work at the church also. Where are you at? |
| 20:40.54 | *** join/#utah mabes (~mabes@66.236.74.194.ptr.us.xo.net) |
| 20:41.29 | goozbach | AWESOME! http://www.youtube.com/watch?v=R55e-uHQna0&feature=player_embedded |
| 20:46.07 | eightyeight | goozbach: indeed. that is AWESOME |
| 20:49.08 | *** join/#utah pashdown_ (pashdown@sine.xmission.com) |
| 21:06.43 | TimRiker | thaddeusq: ROB 3244D |
| 21:07.16 | *** join/#utah emcnabb (~emcnabb@cpe-024-211-241-245.nc.res.rr.com) |
| 21:07.16 | *** mode/#utah [+v emcnabb] by ChanServ |
| 21:07.17 | sjansen | thaddeusq: It's a trap! |
| 21:09.05 | *** join/#utah Heartsbane (tsharpe@unaffiliated/heartsbane) |
| 21:42.42 | *** join/#utah mabes (~mabes@66.236.74.194.ptr.us.xo.net) |
| 22:12.24 | TimRiker | sjansen: indeed. :) |
| 22:18.56 | *** join/#utah clsimons (~csimons@65.122.158.192) |
| 22:48.24 | *** join/#utah Muad`Dib (~sparky@24-104-129.146.hfc.mediarain.com) |
| 23:04.03 | *** join/#utah bmidgley_ (~brad@66.236.74.194.ptr.us.xo.net) |
| 23:04.47 | *** join/#utah tarrant (~tarrant@216.83.139.130) |
| 23:05.33 | *** part/#utah ljenkins (~ljenkins@2001:1948:212::a) |
| 23:05.57 | *** join/#utah ljenkins (~ljenkins@2001:1948:212::a) |
| 23:28.22 | thaddeusq | TimRiker: I meant more what do you do here rather than where exactly. :) I'm actually almost right below you in 2242C |
| 23:30.26 | thaddeusq | TimRiker: BTW, I'm a Linux Engineer on the Data Center Team. |