jhunterj.com

jhunterj.com

J. Hunter Johnson—I'm just this geek you (should) know.

Primary menu

Skip to primary content
Skip to secondary content
  • Home
  • About
  • Privacy Policy

Category Archives: Database

Transforming mostly static data to date ranges

Posted on April 6, 2013 by Hunter — No Comments ↓
A cityscape showing flat peaks and troughs

I recently had to transform a set of data from typical date & measurement to a more compact date range & measurement format. The data in this case was very static: as the date incremented, the measurement was much more Continue reading →

Posted in Database | Tagged sql, transact-sql | Leave a reply

Decoding SQL’s Decode

Posted on February 5, 2013 by Hunter — 1 Comment ↓

I came across a SQL function I was not familiar with: decode. I looked it up and immediately replaced it with a CASE statement (in addition to other code cleanup). I’m afraid I don’t understand the existence of Oracle SQL’s Continue reading →

Posted in Database | Tagged decode, oracle, sql | 1 Reply

Spikes, Slopes, and SQL

Posted on November 8, 2012 by Hunter — 1 Comment ↓

So you have data you’re tracking every day. Maybe a lot of data. Maybe tracking it a lot of ways. You might even have graphs of the data over time, so that you can spot trends and anomalies. And then Continue reading →

Posted in Database | 1 Reply

SSRS Drillthrough Reports for Mobi Reports Pro

Posted on October 24, 2012 by Hunter — No Comments ↓

The short answer: use Globals!ReportFolder in the middle drillthrough reports to fully qualify the target ReportName in any Action. The tech involved in this problem, although probably you know this if you reached this page: SSRS is a database reporting Continue reading →

Posted in Database | Tagged drillthrough, linked reports, mobi reports, ssrs | Leave a reply

jhunterj.com

RSS feed

Subscribe to this site's RSS feed.

Desktop Reader Bloglines Feedly Live Netvibes Yahoo!

Recent Posts

  • The Side Dish of Doom
  • An Open Letter to the FCC About Net Neutrality
  • Calendars and Pi
  • The New Clear Option
  • The Mighty Weretyrannosaurus for Pathfinder

Recent Comments

  • Hunter on Spikes, Slopes, and SQL
  • Hunter on An Open Letter to the FCC About Net Neutrality
  • Hunter on The Mighty Weretyrannosaurus for Pathfinder
  • The New Clear Option | jhunterj.com on Throwing in the Vowel
  • Hunter on Throwing in the Vowel

Archives

  • July 2014
  • May 2014
  • February 2014
  • December 2013
  • November 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • December 2012
  • November 2012
  • October 2012

Categories

  • Database
  • Dayton
  • Film
  • Gaming
  • Meme
  • Meta
  • Money
  • Music
  • Science
  • Time
  • Uncategorized
  • Writing

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
  • Facebook
  • Twitter
  • Google Plus
  • Linkedin
  • Pinterest
Copyright © 2023 jhunterj.com . All Rights Reserved.
Powered by WordPress | Theme: Catch Box