Sorry I've been slacking with this lately. I don't know what's been going on, I build up good momentum on my blog, and then don't update it at all. Ahh well.

Arrive in Vegas on a Thursday night and guess what? IT'S PORING!! I've never seen it rain in Vegas before, and neither have the people who constructed the airport either! It was leaking everywhere!! Makes you wonder how efficient their cooling system is with all the leaks in the roof.

Well, first night was spent in the Luxor casino (which is beginning to show the signs of a beauty queen from 20 years still clinging to old glory...in other words, it's the exact same as it was when it opened 15 years ago, good...but you gotta do something to keep up with the times.

Second day Charlene and I woke up early (which is easy to do with all the oxygen being pumped into your room) and walked all the way down to Slots O Fun. I love those cheesy old casinos...they've got something the bigger places don't: cheap drinks and low limits!

Went to the Mandaly Bay Buffet for dinner. A good choice, not as good as Treasure Island or The Bellagio, but much better than the Aladdin in my opinion. Friday night was spent drinking/gambling (as nights always end). Played some poker at the Luxor (they've got a ghey 50 min/50 max 1/1/2 no limit structure there).

Ok, time for my Vegas Vacation 2006 recap!

Day 1

Flight was supposed to depart at 6:30am...it was pissing rain. Needless to say, the flight was delayed. 3 1/2 hours delayed in fact. So I send a few text messages out while on board the plane and what do I find out? My connection has already taken off from Detroit...FUUUUUUUUCCCCCCCCCCKKKKKKKKKk! We finally land on the ground around 11:30. Long story short, I have to connect in Atlanta to get to San Francisco. By the time I get to San Fran and check into the hotel, it's 8pm...or 11pm my time on a day that I didn't sleep the night before. Once I hit the bed at the hilton, that was it for me. Those beds are soooooooo soft!

Next day, I wake up, grab some sour dough french toast for breakfast...sooooooooo good! Take the ferry to the alcatraz tour. A must see! Get back to Fisherman's wharf, do the touristy area, grab some clam chowder in a sourdough bowl. Head up to Union Square for a bit, ride the trolley and walk down the crooked street. Board a plane and head for vegas.

Vegas will be part II of my Vegas Vacation 06

I've been a bit busier than I thought I would be the last few days, sorry for the lack of a trip report. I'll try to put one up tomorrow, but you'll have to keep coming back to find out if I actually do or not.

Meanwhile, I'm working on a few new queries in Trans4M. This one is to view a list of stockroom issues (parts leaving the stockroom). I hope somebody out there in this world needs it.

SELECT
V_STKRM_MSTR.ACCT_GROUP,
V_STKRM_MSTR.AVG_UNIT_COST,
V_STKRM_MSTR.PART_DESC,
V_STKRM_MSTR.PART_NUM,
V_STKRM_MSTR.STKG_UOM,
V_ACCT_CLASS_TABLE.ACCT_GROUP_DESC,
V_SRC_BAL_HIST.TRANS_QTY * 1 TRANS_QTY,
V_SRC_BAL_HIST.TRANS_TYPE_ACT_CODE,
V_SRC_BAL_HIST.UPD_DATE,
V_SRC_DTL_HIST.EMPL_ID,
V_SRC_DTL_HIST.INV_VAL,
V_SRC_DTL_HIST.SRC_DEPT,
V_SRC_DTL_HIST.SRC_MACH_CNTR,
V_SRC_DTL_HIST.SRC_UNIT_COST * 1 SRC_UNIT_COST,
V_SRC_DTL_HIST.TRANS_REAS_CODE_INFO
FROM
V_STKRM_MSTR,
V_SRC_BAL_HIST,
V_SRC_DTL_HIST,
V_ACCT_CLASS_TABLE
WHERE
({ fn LEFT(V_STKRM_MSTR.ACCT_GROUP, 2) } = ?)
AND (V_SRC_BAL_HIST.UPD_DATE >= ?)
AND (V_SRC_BAL_HIST.UPD_DATE <= ?)
AND (V_SRC_BAL_HIST.TRANS_TYPE_ACT_CODE = ?)
AND V_STKRM_MSTR.PART_NUM = V_SRC_BAL_HIST.PART_NUM
AND V_SRC_BAL_HIST.TRANS_ID = V_SRC_DTL_HIST.KEY_ID
AND V_STKRM_MSTR.ACCT_GROUP = V_ACCT_CLASS_TABLE.ACCT_GROUP

ORDER BY
V_STKRM_MSTR.ACCT_GROUP,
V_STKRM_MSTR.PART_NUM,
V_SRC_BAL_HIST.UPD_DATE,
V_SRC_DTL_HIST.EMPL_ID

If not, no big deal at least if I ever leave this company, I'll have something to look back on.

Well I'm back from my vacation. It was too short (12 days just isn't enough, I could have easily spent another 2 weeks there). I'll do a full recap later on when I get home. Needless to say I had a great time in Southern California (as always) and I seriously want to move there (if it wasn't sooo expensive, I'd probably be there right n0w).

Ok, so I've updated my query to remove the union and replace it with an inner view. Which is good, because I get all the data I need in one row (instead of two) now. Great, sweet! Want to know what sucks, it takes 15 seconds to execute now instead of 2 seconds!!! Ahh well, at least reporting services can hide all the crap for me.

Just in case you were wondering, here's the query.

SELECT bad.HourOfDay as timeHourOfDay, bad.badParts, good.GoodParts FROM
(SELECT
DATEPART("hh",PD_000_00) AS HourOfDay,
COUNT(PD_010_05 ) AS badParts
FROM
RAS3524_ProcessData
WHERE
PD_000_00 >= (getDate() - 1)
AND PD_000_00 <= (getDate())
AND (PD_200_02 <> 'PASS')
GROUP BY
DATEPART("hh",PD_000_00)
) AS bad,
(
SELECT
DATEPART("hh",PD_000_00) AS HourOfDay,
Count(PD_010_05) AS GoodParts
FROM
RAS3524_ProcessData
WHERE
PD_000_00 >= (getDate() - 1)
AND PD_000_00 <= (getDate())
AND (PD_200_02 = 'PASS')
GROUP BY
DATEPART("hh",PD_000_00)
) AS good

WHERE bad.HourOfDay = good.HourOfDay

ORDER BY

timeHourOfDay

And yes, this may be the worst DB for data collection I've ever seen. It'll mark a part as failed, but NOWHERE in the database will it give you the error code it failed on (or even a column to search)