Look What I Wrote Today

You would think after another busy weekend, I would have massive amounts of rambling to do. Perhaps I would share all the intimate details if I wasn’t so tired and coughy. (It’s my blog; I make up my own words.)

Don’t get me wrong, though. The weekend was rather fabulous although I should have slept more.

Plus, the cherry on top was seeing some of my Unspeakable pals, Kow, Bean and fam Sunday night. It was worth the drive to P-town.

Now I’m at work. Surprise. And there’s plenty to do. Surprise.

So rather than take the time to create a witty post about something that happened this weekend, I will simply cut and paste what I wrote this morning for work. Now, you will see why I’m so good at my job… because of the YEARS of honing my mighty writing skills as I earned my English degree from the prodigious BYU. Enjoy this brief, but enormously interesting SQL query:

select distinct

cast (masterSetting.setting_value as varchar(32)) as

‘setting_value’,

mastersetting.CLTD_ID,

test.test_number,

test.test_name,

test.ARUP_TEST_NUM,

test.USE_ARUP_TEST_DATA

from

dbo.tblCLTDMasterSetting mastersetting (nolock)

inner join dbo.tblCLTDSetting setting (nolock)

on mastersetting.setting_id = setting.setting_id

and setting.setting_name = ‘LTD Name’

inner join dbo.tblCLTDTest test (nolock)

on mastersetting.CLTD_ID = test.CLTD_ID

where test.use_arup_test_data <> ‘0’


Political Link of the Day: “Big 3 Bailout: The Ultimate in Lemon Socialism…

Advertisements

4 comments

  1. Awww. That’s nothing. Check out these SQL skillz.

    select distinct olo.ship_to_customer_name, ship.order_number, ship.order_line_number, ship.item_number, olo.quantity_ordered, olo.unit_price, ship.shipped_quantity, ship.short_ship_flag, ship.creation_date, ship.last_update_date, ship.ship_date, ship.process_code
    from sapidmz.xxocwsh_ship_confirm_in_stg_ship
    inner join
    ( select order_number, item_number
    from sapidmz.xxocwsh_ship_confirm_in_stg
    where record_id > 803516706
    and warehouse_id = ‘4TH’
    and partner_id = 84333
    and short_ship_flag = ‘Y’
    ) temp_short on ship.order_number = temp_short.order_number and ship.item_number = temp_short.item_number
    inner join
    ( select order_number, item_number
    from sapidmz.xxocwsh_ship_confirm_in_stg
    where record_id > 803516706
    and warehouse_id = ‘4TH’
    and partner_id = 84333
    and short_ship_flag = ‘N’
    ) temp_ship on ship.order_number = temp_ship.order_number and ship.item_number = temp_ship.item_number
    inner join
    sapidmz.xxocwsh_order_lines_out_stg olo on ship.order_number = olo.order_number and ship.item_number = olo.item_number
    where ship.record_id > 803516706
    and ship.warehouse_id = ‘4TH’
    and ship.partner_id = 84333
    order by ship.order_number, ship.order_line_number, ship.creation_date

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s