Almost a year between posts. Not quite though.

I'm a systems administrator now! YAY!

For today's post I'm just going to link to another blog.

http://www.bramaleainsurgent.com/police-provocateurs-at-summit/

1,010 Posts, last published on Feb 22, 2007

Yes, it's been a long time coming...over half a year, but I am back and better than ever! (just no redesign yet). What have I been up to? Well lets see...in the time since February, I've been to Vegas, England, Ireland, Germany, a few cottages, Atlantic City, Philadelphia, Niagara more times than I care to acknowledge, a (under-20) world cup final, Toronto FC game, 3 Blue Jay games, one job interview (for which I turned down the position), sold a focus and bought a Mazda 3. That's about 6 months of posts right there!

Highlight of all this? I'd have to say going to Berlin was pretty cool, but buying my new Mazda3 Sport GT was far and above my highlight. Got it in Electric Blue, it's so sweet! One day I'll post a picture of it...one day.

I've been slacking lately. I went to Vegas two weeks ago (fun as usual), left with $700 USD in my pocket, came back with $550, so I'll classify that as a good trip! Stayed at the Flamingo which has one of the best locations on the strip. I think I love the poker room there. Don't ask why. It's noisy, the players are bad, but it's just comforting for some weird ass reason.

Anyways, I was checking out autoblog and they've got a story claiming Magna might buy out Chrysler. I'm not a betting man, but being a Magna insider, I'll say this....I don't see it happening. Not unless Magna is guaranteed that they will not be dealing with any sort of a union. Just my opinion.

Sooner or later, I'm going to get around to starting my Christmas shopping. Hopefully within the next week, I hate crowds at malls.

Oh yeah, I forgot to say how much Trans4M makes me want to pull my hair out. Ahh well, at least I'm writing good reports (that they would charge $600 for, but I'm donating to the public for free). Yes, that's Trans4M the ERP system that blows.

Anybody have a better way to optimize this query?

SELECT
V_AR_TRANS_PART.CUST_PART_NUM,
MAX(V_AR_TRANS_PART.CUST_PART_NUM_DESC) PART_DESC,
SUM(V_AR_TRANS_PART.EXT_AMT) EXT_AMT,
SUM(V_AR_TRANS_PART.QTY) QUANTITY,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
AVG(V_AR_TRANS_HDR.FUNC_EQUIV) EXCHANGE_RATE,
V_AR_TRANS_HDR.SHIPTO_CITY,
MAX(V_AR_TRANS_HDR.AR_TRANS_NUM) INVOICE_NUMBER,
(V_AR_TRANS_HDR_TAX_DATA.TAX_PCT * 1) TAXABLE_RATE
from
V_AR_TRANS_PART,
V_AR_TRANS_HDR,
V_AR_TRANS_HDR_TAX_DATA
WHERE
V_AR_TRANS_PART.CREATE_DATE >= ?
AND V_AR_TRANS_PART.CREATE_DATE <= ?
AND HDR_KEY NOT LIKE 'C%'
AND V_AR_TRANS_PART.HDR_KEY = V_AR_TRANS_HDR.AR_TRANS_NUM
AND V_AR_TRANS_PART.HDR_KEY = V_AR_TRANS_HDR_TAX_DATA.KEY_ID
GROUP BY
V_AR_TRANS_PART.CUST_PART_NUM,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
V_AR_TRANS_HDR.FUNC_EQUIV,
V_AR_TRANS_HDR.SHIPTO_CITY,
V_AR_TRANS_HDR_TAX_DATA.TAX_PCT
UNION
SELECT
V_AR_TRANS_PART.CUST_PART_NUM,
MAX(V_AR_TRANS_PART.CUST_PART_NUM_DESC) PART_DESC,
SUM(V_AR_TRANS_PART.EXT_AMT * -1) EXT_AMT,
SUM(V_AR_TRANS_PART.QTY) QUANTITY,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
AVG(V_AR_TRANS_HDR.FUNC_EQUIV) EXCHANGE_RATE,
V_AR_TRANS_HDR.SHIPTO_CITY,
MAX(V_AR_TRANS_HDR.AR_TRANS_NUM) INVOICE_NUMBER,
(V_AR_TRANS_HDR_TAX_DATA.TAX_PCT * 1) TAXABLE_RATE
from
V_AR_TRANS_PART,
V_AR_TRANS_HDR,
V_AR_TRANS_HDR_TAX_DATA
WHERE
V_AR_TRANS_PART.CREATE_DATE >= ?
AND V_AR_TRANS_PART.CREATE_DATE <= ?
AND HDR_KEY LIKE 'C%'
AND V_AR_TRANS_PART.HDR_KEY = V_AR_TRANS_HDR.AR_TRANS_NUM
AND V_AR_TRANS_PART.HDR_KEY = V_AR_TRANS_HDR_TAX_DATA.KEY_ID
GROUP BY
V_AR_TRANS_PART.CUST_PART_NUM,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
V_AR_TRANS_HDR.FUNC_EQUIV,
V_AR_TRANS_HDR.SHIPTO_CITY,
V_AR_TRANS_HDR_TAX_DATA.TAX_PCT
UNION
Select
V_AR_TRANS_MISC.ITEM_NUM,
MAX(V_AR_TRANS_MISC.ITEM_DESC) PART_DESC,
SUM(V_AR_TRANS_MISC.ITEM_PRICE * V_AR_TRANS_MISC.ITEM_QTY) EXT_AMT,
SUM(V_AR_TRANS_MISC.ITEM_QTY) QUANTITY,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
AVG(V_AR_TRANS_HDR.FUNC_EQUIV) EXCHANGE_RATE,
V_AR_TRANS_HDR.SHIPTO_CITY,
MAX(V_AR_TRANS_HDR.AR_TRANS_NUM) INVOICE_NUMBER,
(V_AR_TRANS_HDR_TAX_DATA.TAX_PCT * 1) TAXABLE_RATE
FROM
V_AR_TRANS_MISC,
V_AR_TRANS_HDR,
V_AR_TRANS_HDR_TAX_DATA
WHERE
V_AR_TRANS_MISC.REC_CREAT_DATE >= ?
AND V_AR_TRANS_MISC.REC_CREAT_DATE <= ?
AND V_AR_TRANS_MISC.HDR_KEY NOT LIKE 'C%'
AND V_AR_TRANS_MISC.HDR_KEY = V_AR_TRANS_HDR.AR_TRANS_NUM
AND V_AR_TRANS_MISC.HDR_KEY = V_AR_TRANS_HDR_TAX_DATA.KEY_ID
GROUP BY
V_AR_TRANS_MISC.ITEM_NUM,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
V_AR_TRANS_HDR.FUNC_EQUIV,
V_AR_TRANS_HDR.SHIPTO_CITY,
V_AR_TRANS_HDR_TAX_DATA.TAX_PCT
UNION
Select
V_AR_TRANS_MISC.ITEM_NUM,
MAX(V_AR_TRANS_MISC.ITEM_DESC) PART_DESC,
SUM(V_AR_TRANS_MISC.ITEM_PRICE * V_AR_TRANS_MISC.ITEM_QTY * -1) EXT_AMT,
SUM(V_AR_TRANS_MISC.ITEM_QTY) QUANTITY,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
AVG(V_AR_TRANS_HDR.FUNC_EQUIV) EXCHANGE_RATE,
V_AR_TRANS_HDR.SHIPTO_CITY,
MAX(V_AR_TRANS_HDR.AR_TRANS_NUM) INVOICE_NUMBER,
(V_AR_TRANS_HDR_TAX_DATA.TAX_PCT * 1) TAXABLE_RATE
FROM
V_AR_TRANS_MISC,
V_AR_TRANS_HDR,
V_AR_TRANS_HDR_TAX_DATA
WHERE
V_AR_TRANS_MISC.REC_CREAT_DATE >= ?
AND V_AR_TRANS_MISC.REC_CREAT_DATE <= ?
AND V_AR_TRANS_MISC.HDR_KEY LIKE 'C%'
AND V_AR_TRANS_MISC.HDR_KEY = V_AR_TRANS_HDR.AR_TRANS_NUM
AND V_AR_TRANS_MISC.HDR_KEY = V_AR_TRANS_HDR_TAX_DATA.KEY_ID
GROUP BY
V_AR_TRANS_MISC.ITEM_NUM,
V_AR_TRANS_HDR.CUST_SHIPTO,
V_AR_TRANS_HDR.FCS_CUST_NUM,
V_AR_TRANS_HDR.FUNC_EQUIV,
V_AR_TRANS_HDR.SHIPTO_CITY,
V_AR_TRANS_HDR_TAX_DATA.TAX_PCT

I knew I should have updated the rest of my trip story. Long story short, San Diego is boring, saw Jimmy Kimmel live and San Diego is boring. One day I'll finish off that post...one day.