I hate to break it to you, oh impotent one, but you're not the big bad anymore, you're not even the kind of naughty.

Xander ,'Showtime'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


§ ita § - Jun 03, 2009 6:25:15 pm PDT #10289 of 25501
Well not canonically, no, but this is transformative fiction.

I found it! If your Mac keeps coming up Australian, check the international language settings. Mine were set with Australian English at the top. Changed it to US English (I use Canadian or British sometimes in Windows, but it's never set me asea) and bing.com knows where I am. I may try looking for Gimp again. Not that Australian English should give me French, but I think Canadian French was listed above US English.


tommyrot - Jun 04, 2009 9:46:40 am PDT #10290 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Ooh baby!

CrunchPad internet tablet's launch prototype looks seriously slick

We've been following the progress of Michael Arrington's CrunchPad tablet PC for some time now, but this is the first time I think I actually want one. They've just unveiled the launch prototype, and man is it slick.

This web-centric tablet should be announced officially next month, where details like pricing and availability will hopefully be made known. We'll see if it performs as well as it looks.


Jessica - Jun 04, 2009 9:49:28 am PDT #10291 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Ooh - it's like a GIANT iPod Touch.


amych - Jun 04, 2009 10:18:30 am PDT #10292 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?

I was JUST coming in to post an OMGWANT about the CrunchPad.

tommyrot, if you're gonna live in the other half of my brain, how 'bout getting my to-do list done while you're there?


tommyrot - Jun 04, 2009 10:24:09 am PDT #10293 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

how 'bout getting my to-do list done while you're there?

Sure! As long as you fix this bug that's making stuff round wrong in the SQL Server/MS Access application I'm working on....


brenda m - Jun 04, 2009 10:25:12 am PDT #10294 of 25501
If you're going through hell/keep on going/don't slow down/keep your fear from showing/you might be gone/'fore the devil even knows you're there

Oh man. Want.


§ ita § - Jun 04, 2009 11:15:52 am PDT #10295 of 25501
Well not canonically, no, but this is transformative fiction.

Shiny pretty.

Theoretical SQL question: Given a table with the columns employee number, department, and salary, can you create a SQL statement that lists the highest salary per department where the maximum salary is over $50K?

I get that you need to use the max function, a FROM subquery, and group by, but I'm blanking beyond that.

SELECT MAX(top_salary) FROM (SELECT salary AS top_salary FROM salary_table GROUP BY department) WHERE top_salary>50000

maybe?


tommyrot - Jun 04, 2009 11:29:12 am PDT #10296 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

I'm confused.

Do you want the highest salary of each department, but only if the maximum salary for that department is > 50,000?


§ ita § - Jun 04, 2009 11:35:26 am PDT #10297 of 25501
Well not canonically, no, but this is transformative fiction.

Yes.


tommyrot - Jun 04, 2009 11:38:37 am PDT #10298 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

That's easy. Unless you want the employee number of the highest salary for each department as well. Then you need either a sub-select or the HAVING clause, I think.