There's probably a simpler approach to this.

Just a quick code post at work, I'd wanted a Halloween image which I clearly don't have access to at work, so keeping it just to the code, and maybe I'll put up something Halloween-y later on (assuming I have images that aren't merely leaning to the gothic side of things) and by later I do mean much later, as in another day, as I'll probably be playing Hellgate all evening.

Anyways, SQL madness

select
DATEDIFF(n, pj_print_time_on, pj_print_time_off) [Print Minutes]
,(CAST(pj_print_counter_end AS int) - CAST(pj_print_counter_start AS int)) [Print Total]
,pj_print_spoilage_qty [Print Spoil]
,(((CAST(pj_print_counter_end AS int) - CAST(pj_print_counter_start AS int))) / (DATEDIFF(n, pj_print_time_on, pj_print_time_off))) [Print per Minute]
,pj_comments [Comments]
,DATEDIFF(n, pj_folding_time_on, pj_folding_time_off) [Fold Minutes]
,pj_total_folded [Fold Total]
,((pj_total_folded)/(DATEDIFF(n, pj_folding_time_on, pj_folding_time_off))) [Fold per Minute]
,pj_folding_spoilage_qty [Fold Spoil]
,DATEDIFF(n, pj_insert_time_on, pj_insert_time_off) [Insert Minutes]
,pj_insert_total [Insert Total]
,pj_insert_spoilage_qty [Insert Spoilage]
,((pj_insert_total) / (DATEDIFF(n, pj_insert_time_on, pj_insert_time_off))) [Insert per Minute]
from print_jobs
where DATEDIFF(n, pj_print_time_on, pj_print_time_off) > 0
AND (CAST(pj_print_counter_end AS int) - CAST(pj_print_counter_start AS int)) > 0
AND DATEDIFF(n, pj_folding_time_on, pj_folding_time_off) > 0
AND DATEDIFF(n, pj_insert_time_on, pj_insert_time_off) > 0
AND pj_entered_date_time > @StartDate and pj_entered_date_time < @EndDate

All it really lacks to truly impress myself is variable declaration to avoid the repeated usage of the mathematics in getting the 'per minute' values.

Musings on Tribal M:tG

Okay, less on the musing sort, more just a listing of notables to pair with my draft experience (Which I really should do a bit more often, they're fun). PS: I <3 Ashling, Liliana was nice to see but I don't do Goblins nor Faeries really, so her color wasn't much for the grand plan.

Planeswalkers

Ajani Goldmane - 2WW - Starting Loyality of 4

+1 : You gain 2 Life

-1 : Put a +1/+1 Counter on each creature you control. Those creatures gain vigilance until end of turn.

-6 : Put a white Avatar creature token into play with "This creature's power and toughness are equal to you life total.

Chandra Nalaar - 3RR - Starting Loyality of 6

+1 : Chandra Nalaar deals 1 damage to target player.

-X : Chandra Nalaar deals X damage to target creature.

-8 : Chandra Nalaar deals 10 damage to target player and each creature he or she controls.

Garruk Wildspeaker - 2GG - Starting Loyality of 3

+1 : Untap two target lands.

-1 : Put a 3/3 green Beast creature into play.

-4 : Creatures you control get +3/+3 and gain trample until end of turn.

Jace Beleren - 1UU - Starting Loyality of 3

+2 : Each player draws a card.

-1 : Target player draws a card.

-10 : Target player put the top twenty cards of his or her library into his or her graveyard.

Liliana Vess - 3BB - Starting Loyality of 5

+1 : Target player discards a card.

-2 : Search your library for a card, then shuffle your library and put that card on top of it.

-8 : Put all creature cards in all graveyards into play under your control.

Dual Lands (Reveal or comes in Tapped)

W or R (Giant) Ancient Ampitheater, B or R (Goblin) Auntie's Hovel, B or G (Elf) Gilt-Leaf Palace, U or B (Faerie) Secluded Glen, W or B (Merfolk) Wanderwine Hub

Legendaries

Ashling the Pilgrim - 1R - 1/1 Elemental Shaman

1R : Put a +1/+1 counter on Ashling the Pilgrim. If this is the third time this ability has resolved this turn, remove all +1/+1 counters from Ashling the Pilgrim, and it deals that much damage to each creature and each player.

Brigid, Hero of Kinsbaile - 2WW - 2/3 Kithkin Archer

First Strike

Tap : Brigid, Hero of Kinsbaile deals 2 damage to each attacking or blocking creature target player controls.

Brion Stoutarm - 2RW - 4/4 Giant Warrior

Lifelink

R Tap : Sacrifice a creature other than Brion Stoutarm: Brion Stoutarm deals damage equal to the sacrificed creature's power to target player.

Doran, the Siege Tower - UGW - 0/5 Treefolk Shaman

Each creature assigns combat damage equal to its toughness rather than its power.

Gaddock Teeg - GW - Kithkin Advisor

Noncreature spells with converted mana cost 4 or greater can't be played.

Noncreature spells with X in their mana costs can't be played.

Horde of Notions - WUBRG - 5/5 Elemental

Vigilance, trample, haste

WUBRG : You may play target Elemental card from your graveyard without paying its mana cost.

Nath of the Gilt-Leaf - 3BG - 4/4 Elf Warrior

At the beginning of your upkeep, you may have target opponent discard a card at random.

Whenever an opponent discards a card, you may put a 1/1 green Elf Warrior creature token into play.

Sygg, River Guide - WU - 2/2 Merfolk Wizard

Islandwalk

1W : Target Merfolk you control gains protection from the color of your choice until end of turn.

Wort, Boggart Aunite - 2BR - 3/3 Goblin Shaman

Fear

At the beginning of your upkeep, you may return target Goblin card from your graveyard to your hand.

Wydwen, the Biting Gale - 2UB - 3/3 Faerie Wizard

Flash

Flying

UB, Pay 1 Life : Return Wydwen, the Biting Gale to its owner's hand.

Incarnations

Dread - 3BBB - 6/6 Elemental Incarnation

Fear

Whenever a creature deals damage to you, destroy it.

When Dread is put into a graveyard from anywhere, shuffle it into its owner's library.

Guile - 3UUU - 6/6 Elemental Incarnation

Guile can't be blocked except by three or more creatures.

If a spell or ability you control would counter a spell, instead remove that spell from the game and you may play that card without paying its mana cost.

When Guile is put into a graveyard from anywhere, shuffle it into its owner's library.

Hostility - 3RRR - 6/6 Elemental Incarnation

Haste

If a spell you control would deal damage to an opponent, prevent that damage. Put a 3/1 red Elemental Shaman creature token with haste into play for each 1 damage prevented this way.

When Hostility is put into a graveyard from anywhere, shuffle it into its owner's library.

Purity - 3WWW - 6/6 Elemental Incarnation

Flying

If a spell or ability would deal damage to you, prevent that damage. You gain life equal to the damage prevented this way.

When Purity is put into a graveyard from anywhere, shuffle it into its owner's library.

Vigor - 3GGG - 6/6 Elemental Incarnation

Trample

If damage would be dealt to a creature you control other than Vigor, prevent that damage. Put a +1/+1 counter on that creature for each 1 damage prevented this way.

When Vigor is put into a graveyard from anywhere, shuffle it into its owner's library.

Commands

Austere Command - 4WW - Sorcery

Choose two - Destroy all artifacts; or destroy all enchantments; or destroy all creatures with converted mana cost 3 or less; or destroy all creatures with converted mana cost 4 or greater.

Cryptic Command - 1UUU - Instant

Choose two - Counter target spell; or return target permanent to its owner's hand; or tap all creatures your opponents control; or draw a card.

Incendiary Command - 3RR - Sorcery

Choose two - Incendiary Command deals 4 damage to target player; or Incendiary Command deals 2 damage to each creature; or destroy target nonbasic land; or each player discards all the cards in his or her hand, then draws that many cards.

Primal Command - 3GG - Sorcery

Choose two - Target player gains 7 life; or put target noncreature permanent on top of its owner's library; or target player shuffles his or her graveyard into his or her library; or search your library for a creature card, reveal it, put it into your hand, then shuffle your library.

Profane Command - XBB - Sorcery

Choose two - Target player loses X life; or return target creature card with converted mana cost X or less from your graveyard to play; or target creature gets -X/-X until end of turn; or up to X target creatures gain fear until end of turn.

Championers

Boggart Mob - 3B - 5/5 Goblin Warrior

Champion a Goblin

Whenever a Goblin you control deals combat damage to a player, you may put a 1/1 black Goblin Rogue creature token into play.

Nova Chaser - 3R - 10/2 Elemental Warrior

Champion an Elemental

Trample

Thoughtweft Trio - 2WW - 5/5 Kithkin Solider

Champion a Kithkin

First Strike, Vigilance

Thoughtweft Trio can block any number of creatures.

Wren's Run Packmaster

Champion an Elf

2G : Put a 2/2 green Wolf creature token into play.

Each Wolf you control has deathtouch.

Changeling Beserker - 3R - 5/3 Shapeshifter

Changeling

Champion a Creature

Haste

Changeling Hero - 4W - 4/4 Shapeshifter

Changeling

Champion a Creature

Lifelink

Changeling Titan - 4G - 7/7 Shapeshifter

Changeling

Champion a Creature

Tribal Leads

Imperious Perfect - 2G - 2/2 Elf Warrior

Other Elf creatures you control get +1/+1.

G Tap : Put a 1/1 Elf Warrior creature token into play.

Incandescent Soulstroke - 2R - 2/2 Elemental Shaman

Other Elemental creatures you control get +1/+1.

1R Tap : You may put an Elemental creature card from your hand into play. That creature gains haste until end of turn. Sacrafice it at end of turn.

Mad Auntie - 2B - 2/2 Goblin Shaman

Other Goblin creatures you control get +1/+1.

Tap : Regenerate another target Goblin.

Merrow Reejerey - 2U - 2/2 Merfolk Solider

Other Merfolk creatures you control get +1/+1.

Whenever you play a Merfolk spell you may tap or untap target permanent.

Scion of Oona - 2U - 2/2 Faerie Solider

Other Faerie creatures you control get +1/+1.

Flash

Flying

Other Faeries you control have shroud.

Sunrise Sovreign - 5R - 5/5 Giant Warrior

Other Giant creatures you control get +2/+2 and have trample.

Timber Protector - 4G - 4/6 Treefolk

Other Treefolk creatures you control get +1/+1.

Other Treefolk and Forests you control are indestructible.

Wizened Cenn - WW - 2/2 Kithkin Cleric

Other Kithkin creatures you control get +1/+1.

Tribal Enchantments

Boggart Shenanigans - 2R - Tribal Enchantment (Goblin)

Whenever another Goblin you control is put into a graveyard from play, you may have Boggart Shenanigans deal 1 damage to target player.

Eyes of the Wisent - 1G - Tribal Enchantment (Elemental)

Whenever an opponent plays a blue spell during your turn, you may put a 4/4 green Elemental creature token into play.

Faerie Tauntings - 2B - Tribal Enchantment (Faeire)

Whenever you play a spell during an opponent's turn, you may have each opponent lose 1 life.

Favor of the Mighty - 1W - Tribal Enchantment (Giant)
Each creature with the highest converted mana cost has protection from all colors

Hoofprints of the Stag - 1W - Tribal Enchantment (Elemental)
Whenever you draw a card, you may put a hoofprint counter on Hoofprints of the Stag.
2W : Remove four hoofprint counters from Hoofprints of the Stag: Put a 4/4 white Elemental creature token with flying into play. Play this ability only during your turn.

Merrow Commerce - 1U - Tribal Enchantment (Merfolk)

At the end of your turn, untap all Merfolk you control.

Kithkin Pride - 1W - Tribal Enchantment (Kithkin)

Whenever a nontoken creature you control attacks, you may pay W. If you do, put a 1/1 white Kithkin Soldier creature token into play tapped and attacking.

Prowess of the Fair - 1B - Tribal Enchantment (Elf)

Whenever another nontoken Elf is put into your graveyard from play, you may put a 1/1 green Elf Warrior creature token into play.

Rebellion of the Flamekin - 3R - Tribal Enchantment (Elemental)

Whenever you clash, you may pay 1. If you do, put a 3/1 red Elemental Shaman creature token into play. If you won, that token gains haste until end of turn.

Fun Extras

Cairn Wanderer - 4B - 4/4 Shapeshifter

Changeling

As long as a creature card with flying is in a graveyard, Cairn Wanderer has flying. The same is true for fear, first strike, double strike, deathtouch, haste, landwalk, lifelink, protection, reach, trample, shroud, and vigilance.

Forced Fruition - 4UU - Enchantment

Whenever an opponent plays a spell, that player draws seven cards.

Aaah, Fall

Woot, missed September entirely. Somewhere between the job and the diversion-turned-lifestyle that is World of Warcraft I didn't really find the time nor content to eek out a full blown post in that time. A pair of half sorted anime image sites/folders, a partially organized music folder, 2 nearly renamed folders of anime (as I move them from viewed to storage on the USB HD), and the flash fueled distractions of Adventure Quest (58!) and DragonFable (9!) during my semi-unimpaired at Saturday work aren't really contributing to the efforts.

Overlooking the facts that Adult Swim seems to be running both a 2003 Calendar remarked for 2007 events and time-line accurate calendar that claims they were running Blood+ episodes 111-125 over the course of weeknights on the second and third week of September, it appears at present that they'll be replacing Bleach with Death Note after the end of the second "season" chronologically, though Bleach originally actually ran 52-53 as a double episode and this sorta cuts right before the good stuff of the Soul Society so I wonder what it is they're actually doing, or if they genuinely only have the first 2 sets of 26 at their disposal, which would be sad.

So, in the realm of anime here it goes.

I still haven't watched Hayate nor RxJ, I've decided that I'm totally dropping the former but likely to grab and watch the full series batch of the later from Umai.

With Black Order's staff vacations and A.F.K. doing, well, I have no idea what, my progress in Sayonara, Lucky Star, and Gurren Lagann have all ground to a painful halt. I'm eagerly anticipating all 3, but only LS really has any progression outside A.F.K. (Guerrand to completion, though 3 groups have all done the next episode of SZS). Also, I'm kinda curious exactly what the rest of Doujin Work looks like, I didn't think your-mom dropped series.

Darker than Black and Idolm@ster Xenoglossia are both headed towards their respective ends, and the screens for both look promising. I'm holding a bit of hope that DtB'll get picked up again at another date as Hei x Misaki was a fun pairing, or even the more fanart-beloved Hei x Ying.

Someone has taken up the chalice of School Rumble Season 2, which is great news for as much as I detest an unhealthy portion of the cast, it's still amusing enough to counterbalance. I just have to look at it not as romantic comedy/drama but instead as pure school comedy with a bit of Eri service.

Zombie Loan
Somewhere between the random philosophical musings on the nature of existence, the random allies, the shounen-ai, the yuri, the less than stellar production quality, anticlimactic battles, and the numerous major story lines completely left unfinished (Grim Reaper, the Yakuza, Ferryman, and the other Zombie organization, not to mention everything involving the Headmistress and the wolf-spirit) there just isn't much good that I can say about the show. There was certainly potential but all they managed to do was laying characters atop characters, alluding to other events and people, and resolving none of it.

Verdict - It's not getting licensed, I don't see why it would since it'd be nothing either than a waste of money, but save yourself the trouble and skip this one.

Claymore
Okay, so the death of Flora makes me very sad, as she outshone pretty much all the other Claymores in terms of looks and style in her short time amongst the cast. Raki is at least thankfully coming across less like the whiny, lonely, over-entitled brat I grew to hate his as. I'm not overly concerned with the remainder of the Claymore force stationed at Pieta, but I am curious as to what it was that Galatea destroyed in that Church. As an aside, the jumping between falling fragments of the chunk of earth portion of the battle was amazing.

Verdict - Too many pieces still left up in the air so here's hoping for another 26 in a year or two when there's more manga to support it. Also hoping that those 26 involve more than just Claire, I don't think a single Claymore can defeat a Dweller, I think teamwork really is and should be key, both in terms of telling a good story and in terms of logic.

Blood+
Took me what, 3 weeks to eventually pour through all of this? There was a ton less fighting that I hoped for, loss of all the good Sif, Mao accomplishes little since she's essentially encouraging a love that isn't meant to be (and on some levels ticks that "related but not by blood" nerve) but there's just something about cameramen I guess (direct Speed Grapher reference, I admit). Too much of the fighting isn't Saya, and a lot of that isn't even Haji either, too many battles end when Diva's Chevalier's cancel each other out.

Still a few pieces left at the end, namely the origin, purpose, and end of Nathan, given the events after his supposed death.

From the Wiki, did I just miss this part in one of the flashbacks somewhere?

• 1945 James becomes a Chevalier in Berlin. Acting on orders from Amshel, Solomon kills Martin Bormann, another Chevalier and a high-ranking Nazi. End of the Second World War.

Verdict - Glad that everything seemed to land in the proper places and was a fun trip getting there. Some of the flashbacks didn't really suit me, but at least they got the kids out of the picture pretty quickly (since the two of them were Eureka level annoyance combined with Kai's wishy-washy "I can't do anything" versus "I want to protect her"). Definitely glad I found the time to watch it, but not sure I'd do it again given the chance. Needed more Sif.

Bleach Movie : Memories of Nobody
Senna > Rukia & Inoue. But that's from a perspective that stopped when Soul Society did. Takes a bit of time, and plenty of oddness to get to the actual meat of the story (the last 20 minutes of warfare) but at least it's a decent trip. Being someone who stopped before even the wind-down of Soul Society I was pleased to just watch the old crew go to town against some fresh blood. Kenpachi's fight was too ridiculously over-the-top one-sided to keep a straight face at. Nice to see Rukia's "Blue Moon" since obviously she didn't do any fighting in the series through the course of Soul Society.

Verdict - Didn't quite inspire me to pick Bleach up again yet, but came close. Will probably have to pick up the manga though (yet I've been saying this about a ton of other series as well, and while I did DL Claymore's I haven't yet gotten to it.)

-- Since starting this both Lucky Star and Doujin Work have seen some loving, so I'll get to those, Jeanne, and the new season's pickings whenever I find the time to post again.