irclog2html for #uphpu on 20051115

02:12.15*** join/#uphpu synic (n=synic@c-67-177-16-249.hsd1.ut.comcast.net)
02:39.23*** join/#uphpu bigdog_ut (n=bigdog_u@shylonhunter.dsl.xmission.com)
02:39.23*** mode/#uphpu [+o bigdog_ut] by ChanServ
02:39.49*** join/#uphpu bigdog_ut (n=bigdog_u@shylonhunter.dsl.xmission.com)
02:39.50*** mode/#uphpu [+o bigdog_ut] by ChanServ
03:02.56*** join/#uphpu wps (n=wade@65.73.113.199)
03:03.01*** mode/#uphpu [+o wps] by ChanServ
05:35.29*** join/#uphpu bigdog_ut (n=bigdog_u@thebigdog.biz)
05:35.29*** mode/#uphpu [+o bigdog_ut] by ChanServ
15:31.18*** join/#uphpu wps (n=wade@207.135.130.2)
15:31.21*** mode/#uphpu [+o wps] by ChanServ
15:50.51mindjujuany sql gurus in da house?
15:50.53mindjujumacnewbold or bigdog, any of you guys around?
15:50.53mindjujuk, well here is my question and if anybody has any suggestions
15:51.08*** join/#uphpu wps (n=wade@207.135.130.2)
15:51.11*** mode/#uphpu [+o wps] by ChanServ
15:51.31mindjujui've got a query with a couple of subqueries.  Now one of the subqueries is bringing back a date and I need to find out how many days apart from today that is. (forexample, 11/10/2005 was 5 days ago).  I want the sql server to do the math
15:52.36mindjujuso i know how to write the datedif query, but wondering if i should just dump everything into a temp table to be able to do the math, or should i try to compress everything into one query
15:56.37macnewboldmindjuju: I'm here now
15:56.46ssddmindjuju, I would just do everything in one query.  I am guess that it would be less overhead than creating a temporary table
15:57.37mindjujuk, there is just one hang up.  this table that has the date that i'm doing the diff on, it has a record for everytime that somebody did something
15:57.50mindjujuso, i've got to ask for the lastest date that a person in particular did something
15:57.54mindjujuso
15:58.35ssddoh
15:58.42macnewboldmindjuju: if you want just the latest date from each person, you'll have to do select person,max(date) from table group by person;
15:58.44mindjujuSELECT DATEDIFF (day, date_created, getdate())  
15:58.44mindjuju<PROTECTED>
15:58.44mindjuju<PROTECTED>
15:59.04mindjujui did use max, but sql seemed to freak out
15:59.07mindjujuit looked like this
15:59.15macnewboldremember though that if you select other fields, they won't match with the row that the max date was found
15:59.57mindjujuSELECT MAX(DATEDIFF (day, date_created, getdate()))  
15:59.57mindjuju<PROTECTED>
15:59.57mindjuju<PROTECTED>
16:00.23ssdddoes that work?
16:00.30mindjujunope, it freaked out
16:00.35mindjujubut looking at it here again
16:00.46mindjujui prolly should have put max inside the datedif
16:00.50mindjujunot the other way around
16:01.22ssddworth a shot
16:01.57mindjujuk, it's humming, the table has like 2 mil records so takes a minute
16:02.00macnewboldhehe
16:02.12macnewbolddo you want the difference from the max, or the max of the differences?
16:02.30macnewboldit's a lot easier to evaluate the former, because it does max on a field, not a max on a difference
16:02.33mindjujuk, that was it
16:02.44mindjujudifference from the max
16:02.54mindjujuthnx ya'll!
16:04.18ssddminjuju, just curious what db are you are using?
16:04.42mindjujuMS SQL 2k for this application
16:04.50ssddoh...
16:05.01ssddgood luck
16:05.03mindjujuyeah, i know i know
16:05.09mindjuju:)
16:05.59mindjujuwasn't really my call, but make do with what you got.  and it isn't a fate worse than death, its just somewhere near that
16:06.21ssddbeen there :(
16:07.23mindjujuthough initially we were thinking of jumping to ms sql2k5, now i've stopped that for the next year.  my understanding is that with MS Visual Studio 2k5 already scheduled to have a service pack and it just came out, sql 2k5 and business server 2k6(?) supposed to be heavily dependant on vs2k5, it makes me wonder how stable those are going to be
16:08.05ssddgood to know
16:08.41*** join/#uphpu synic (n=synic@pdpc/supporter/student/synic)
16:09.39ssddI was hoping you were doing it with mysql 5
16:09.42mindjujuactually haven't downloaded that yet.  i've got an app still running on mysql 4.3
16:09.48mindjujuexcited to see how stored procs are working
16:09.52mindjujuhave you tried it?
16:09.57ssddno
16:10.05ssddneed to
16:12.58mindjujuso ssdd, is your handle from like the old 5 1/4 inch disks or does it have another meaning?
16:14.21ssddit is from Steven King's Dreamcatcher
16:14.24ssddamong other places
16:14.37ssddsame stuff different day
16:15.00RyanEGuess that makes more sense than single sided / double density.  :)
16:15.10ssddLOL
16:15.10mindjujuheh, hilarious!
16:15.28mindjujuyeah, that's what i thought it was, forgot about the same s*** different day
16:15.29ssddthat works too
16:15.56ssddguess I could use that in geeky circles
16:16.35mindjujuwell, if it makes any difference, i just finished reading an article about how some programmers are bringing back text based games like Zork, then i got to thinking about old times...
16:16.58ssddsaw that
16:18.09ssddI don't play games that much be when I do it is usually grab gun,  turn off brain and kill kill kill
16:19.02mindjujuyeah, i'm big fan of Halo 2.  (insert plug here about how uphpu should have LAN party)
16:19.05*** join/#uphpu xilch (n=xilch@c-67-166-119-0.hsd1.ut.comcast.net)
16:19.12synicxilch: pansy
16:19.40xilchsynic: no yuo
16:19.48synicno you
16:20.00xilchsynic: jbother is bustored from here
16:20.07synicin what way?
16:20.16xilchcan't connect
16:20.44xilchbut i have to watch gavin for about .5 hr
16:20.56synicgets t3h new jbother nightly
16:21.02xilchso I'll be working from here
16:21.20xilchsynic: i tried that
16:22.43xilchI get a sasl error
16:23.14xilchdunno what that means though
16:23.38synic(un)check ssl or something
16:24.00*** join/#uphpu optikal (n=optikal@64.50.125.200)
16:24.10synicxilch: http://www.sandisk.com - check out the menus and flash
16:29.19synicworks in IE, though
16:29.36xilchsynic: the menus don't popup
16:29.38synicany css gurus know how to get those menus to show up over the flash in firefox?
16:29.44xilchsynic: that only in firefox?
16:29.49synicxilch: yeah
16:29.53xilchI see
16:31.59mindjujuyeah, give me a sec
16:32.37xilchsynic: http://www.xtreeme.com/dhtml/faq/answers/Q3025.php
16:32.47xilchthat might do it
16:33.06mindjujuk, in the object put this line
16:33.14mindjuju<param name="wmode" value="transparent" />
16:33.32mindjujufor ie to be friendly put this line in the embed
16:33.40mindjuju<PROTECTED>
16:39.16mindjujudid that work for you?
16:39.36synicI'm trying to find the flash file, hehe
16:39.41synicxilch: do you know what it's called?
16:39.52xilchoh you've done it now, idiot
16:40.00synicI should have just commented that part out....
16:40.03xilchhehe
16:41.52syniccrap, no answer.
16:42.09xilchspiceuptheseason.swf
16:42.44synicthat's not it
16:44.03synicnatalietesting/Thanksgivingflash/thanksgivingflash.swf
16:45.36xilchsynic: it's not in thanksgivingflash?
16:45.50xilch(in htdocs)
16:46.57synicthere isna one.
16:47.46synicmacnewbold: works in windows, not in linux
16:50.21dataw0lfwho is natalie?
16:50.26dataw0lfas in natalie dee, my heroine?
16:54.14xilchsynic: check htdocs/Thanksgivingflash
16:54.16xilchsynic: it's there
16:54.36xilchdataw0lf: natalie is our flash designer
16:55.09synicxilch: well, it works in firefox on windows, IE, and Safari.
16:55.17dataw0lfis she hawt?
16:55.28xilchdataw0lf: not really - plus, she's married
16:55.32RyanEyeah!  dw is back!  w00t!
16:55.33xilchand lives in logan
16:55.39dataw0lfoh
16:55.40dataw0lfoh
16:55.48RyanEI could have done an irssi |grep 'hawt' to see if dw had returned.  :)
16:55.52dataw0lfI dunno, I think me and Nicole are really hitting it off anyways.
16:56.01dataw0lfRyanE: hehe
16:56.03RyanEis she hawt?  :
16:56.07RyanE:)
16:56.08dataw0lfsuper hawt
16:56.14dataw0lfwww.myspace.com/nicolekillsit
16:57.12synicer.. mindjuju
16:57.17synic[09:47:55] synic: macnewbold: works in windows, not in linux
16:57.44dataw0lfya right
16:57.49dataw0lfre: xilch going to heaven
17:06.55macnewboldsynic: what works in windows not linux?
17:07.15synicmacnewbold: sorry, that was for mindjuju
17:08.18macnewboldit's okay
17:08.25macnewboldthat explains why I was confused
19:10.38*** join/#uphpu fungus (n=fungus@firebat.aros.net)
23:24.23*** join/#uphpu jsmith (n=jsmith@vpnpip.dal.omniture.com)
23:34.47*** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com)

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.