I don't know why this one is giving me such trouble - I've written much more complex queries. Table OITM has ItemCode and Vendor - 1 line per item. Table OITW has ItemCode, WarehouseCode, BOH (balance on hand) and MTD_Sales - 1 line per item per WH. For Vendor XYZ, I'm trying to get a list of ItemCodes with total BOH and total MTD_Sales for all ( Read more... )

Wait, you were serious about Cajun *SQUIRREL*? There are SQUIRREL FLAVORED POTATO CHIPS? Have I suddenly fallen into a parallel universe? Some alternate reality in which a horde of conquering Appalachian hillfolk took over the cooking schools of the entire world ( Read more... )

I would totally drive this car....

Wah - I left the book I'm reading at work! This means I either have to drive 40 minutes (20 there, 20 back) to get it, or find something else. Oh well, it's not like I haven't read it a dozen times before - Mel Keegan's Fortunes of War[1] Yes, Mel Keegan. I admit it - Fortunes of War and East Wind Blowing are two of my can-read-over-and-over- ( Read more... )

Did I already link to this? Or am I loosing my mind?

Click to view

This is what I spent most of my morning working on (in between writing SQL queries)...


( Read more... )

I'm pretty sure I'm not the only one around here who thinks Mitch Hewer is a hot little hottie...

OH, mighty SQL gurus on my flist..... So, I've got this table that records rental transactions. It has the TransactionDate, ItemID for the item, and the Action (Rented or Returned). For entries that are Rented, it also has CustomerID for the person who rented it. What it does NOT have is the CustomerID for the Return entries. I'm trying to ( Read more... )

It's cold and rainy[1] here in SD, and I'm pondering what to have for le diner. What's your favorite rainy-day warm&comfort food?

--
1] Water! Falling from the sky! It's a miracle!

Dinner tonight - pizza, with chicken sausage, green onions, tomatos and apples....

What's the craziest thing you've ever put on a pizza?