rblog

Sun after rain - steamy roof

Rune Hellem — Thu, 17 May 2012 10:49:00 +0000

National day today, quite cold, rainy morning, after rain comes sun.

Handy SQL

Rune Hellem — Mon, 14 May 2012 16:16:00 +0000

Created this SQL-statement used for one of our JIRA-instances. Needed to get rid of a lot of open sub-tasks where the parent task had been cancelled. The statement also shows usage of inner join and self-join.

Code:

U PDATE jiraissue ji1, jiraissue ji2
INNER JOIN issuelink il
SET ji1.resolution = 9, ji1.issuestatus = 6
WHERE ji1.resolution  IS NULL
AND ji1.id = il.destination
AND ji1.issuestatus = 1
AND il.source = ji2.id
AND ji2.resolution = 9;

Original post blogged on b2evolution.

Todays view

Rune Hellem — Mon, 14 May 2012 08:36:00 +0000

Today having this view while working.

Not a local? Mosjøen

Original post blogged on b2evolution.

My latest book: Philip Short "Pol Pot - Anatonmy of a Nightmare"

Rune Hellem — Sat, 12 May 2012 21:20:00 +0000

A lot of details, hard to follow the story due to many names to keep track of, almost grueling to read, but most of all a terrifying story of what a few men are able to make a whole nation go through.

Lots of clips to be found on Youtube

Original post blogged on b2evolution.

Dive!!! "Stupe læll"

Rune Hellem — Sat, 12 May 2012 16:36:00 +0000

Crazy mothafucka if you ask me!!

Original post blogged on b2evolution.

Communal duty work

Rune Hellem — Fri, 11 May 2012 18:37:00 +0000

On Wednesday, communal duty work (dugnad) in the kindergarten. Five blisters, but the sandboxes are much safer after we have dug up the sand and also swept the asphalt.

Original post blogged on b2evolution.

Askerrunden 2012

Rune Hellem — Tue, 08 May 2012 19:03:00 +0000

Last Sunday I participated in Askerrunden, 67 kilometers in...Asker...quite happy with the result all in all. 33 of 39 ain't no good, but the time was ok. Sick two weeks ago, so I was very happy that I was able to hang in there together with a few others. Was not able to help them as much as I wanted, but they helped me a lot...

Found this video, have to work harder next year so I can get a part in the movie as well :-)

Original post blogged on b2evolution.

Got a Nissan Micra you want to get rid of?

Rune Hellem — Sat, 05 May 2012 19:39:00 +0000

Have been watching all episodes of Team Bachstad, Mongol Rally 2011. Loved it! A natural follow up after having watched Long Way Round and Long Way Down.

You can participate this year as well...and need to use a...Nissan Micra....

To tackle the worst roads in the world you you need a chariot with an engine size of under 1 litre (ish). There is nothing like staring down the bonnet of a Nissan Micra at hundreds of miles of dirt track and foot-high rocks.

http://www.theadventurists.com/the-adventures/mongol-rally

Off course you can do it as a charity ride as well, like the Norwegian girls CookingCharityChicks are supposed to do

Also, a lot of clips to be found on Youtube

Original post blogged on b2evolution.

	`U PDATE jiraissue ji1, jiraissue ji2`
	`INNER JOIN issuelink il`
	`SET ji1.resolution = 9, ji1.issuestatus = 6`
	`WHERE ji1.resolution IS NULL`
	`AND ji1.id = il.destination`
	`AND ji1.issuestatus = 1`
	`AND il.source = ji2.id`
	`AND ji2.resolution = 9;`