mmrmnhrm

Mind you, rabbits eat their own poop. My sister had a rabbit for what seemed like 50 years (ok, she actually got it in Jr High, and it died shortly before Thanksgiving, making it something like 10 years old), but that's about all it ever did. Eat, poop, eat, poop, eat, poop... and yes, while you can litter train them, the sheer amount of poop these critters generate typically overwhelms the box within a short time period. Great for teaching kids chores/responsibility, but that's about it. Unless, like a rabbit, you also enjoy eating poop. But if you do, I don't want to talk to you.

Pure awesome, mate... all I had to do was change [GroupID] to [groupID] and the thing worked!

Brandon... make that "I see a hole in the code" How should SQL determine whether or not there's a planet to count without a comparison against groupID=7 (same for moons/8 and belts/9)? Add: The database (in MSSQL backup format) is available here, 104MB.

Sean: Yes Brandon: Your code makes sense to me, but perhaps I'm not copying it correctly (though this being the first time I've ever tried to use SQL, I might be missing something obvious) (yes, I did remember to change 'JOIN [dbo].[OtherTableName] B' to 'JOIN [dbo].[mapDenormalize] B') I get the following error out: Vince: Was pretty sure JOIN was a part of it, since there are two tables involved... just never done anything remotely like this before, so it's sorta like giving a toddler some wrenches and telling them to tune a Shelby

Have a big-ass database I'm trying to pull some info out of, which exists in two tables. Most of what I need is in the first, does not require any special coding, and I've got that running ok. However, there are three pieces of info which live in the second which I need to tally up based on their groupID value, then append to the results, followed by a pair of zeros. A full result looks like this: Tanoo,30000001,20000001,-8.85107925999806e16,4.23694439668789e16,-4.45135253464797e16,0.858324068848468,6,7,4,0,0 (system name, system id, constellation id, x-y-z coordinates, security level, # planets, # moons, # belts, 0, 0) "System ID" is a primary key which exists in both tables. In the second table, all planets are groupID=7, moons are groupID=8, and belts groupID=9. The bold portion is being retrieved with this query: Now I just need some help getting that last little underlined piece, which lives in [dbo].[mapDenormalize]

Things to watch out for (and which I just had to ping people about here at the office) - Extension cords plugged into extension cords. Long wire runs mean heat and every connection is another point of potential arcing and failure. This includes "heavy duty" versions! - Heaters plugged into extension cords or power strips. Not only do you have the arc potential of multiple connection points (previous point), but all too often, people use stupid little 18AWG cords meant for Christmas trees and table lamps, and those WILL heat up something wicked when loaded with a 1000W floor heater.

:fuuuu: :fuuuu: :fuuuu: :fuuuu: :fuuuu: :fuuuu: :fuuuu: (Though I have to admit, wifey would probably be upset if I just brought another tank home, even if it was free)

Box or bowfront?

Wish I had another 26m to watch it all again

http://www.roflcat.com/images/cats/270911970_db35fdd4ca.jpg In other news... no. It's just your screwed up, virus-riddled, shit system together with your half-baked, two bit service provider. Maybe if you stopped following all those Linn links, you wouldn't be in this mess :gabe:

You're gonna shoot me with *THAT*?? Get real. :megusta:

Yep... I bought it from Paul specifically because it had both. The equipment used to time sports events (swimming, water polo, track, etc) has only started including USB and/or Ethernet ability in the last few years. Most independent contractors and small to mid-size schools haven't upgraded, so RS232 is the only way the meet management software (which runs on the computer) can transfer event lists and results to and from the timing console.

Mail sent

Up to you, really... If you figure you'll need real serial often, make an offer and I'll wipe+install whatever you like on it (assuming I have a legit copy). Otherwise, it collects dust for about 95% of the time, and it won't be missed if you need it for a couple days.

I've got the c610 I bought off Paul a couple months back if you're still looking. It triple-boots w98/XP/SuSE now, but should do just fine for a serial/ODBII type diagnostic.

If it smells like a scam, and your scamdar is going off, it's a good bet you're being scammed.

You know you're a child of the 80's when the phrase "I know what I'm doing" makes you think of .

You'll never get "perfect" cancellation no matter how much you spend (right now, anyways). Something will always bleed through, and that's where you add in new noise/music/talk/soothingoceansounds/whatever to cover up the difference.

Much noise about nothing... countries like Iran, China, NKorea, Pakistan... you know, the usual suspects, are going to go in and demand UN control of the Internet on the grounds of anti-blasphemy, anti-dissent, and whatever BS they feel like trumping up. America will say STFU, we invented it and things work just fine thank-you-very-much, and that'll be that.

Galactica?

dd if=/dev/dvd of=the_matrix.iso

I think not being willing to part them out is the problem... I have 400W MH lamps at the office, for example, but the rest of them are completely useless to me.

Probably. From the article: In other words, it will no longer have a preset on my car.

Winner

Nurk: Expedient (the one I'm occasionally posting NOC or sales openings for). We've always got a sort of general "if we find someone really awesome we'll grab 'em before our competitors do" type search going on. Most of our specific "we need exactly $DESCRIPTION" openings are at other cities right now, but programmers could be anywhere, so if he's hot, send me his stuff.