You Are Monday
Like this day of the week, you are ruled by the moon.
More than anything, you are flexible.
You are moody and impressionable. You are easily influenced by the world around you.
And while you can be temperamental, you eventually adjust.
While Mondays tend to be the hardest day for people, you don't mind getting back to regular life.
You're the one waking up early and making the coffee while everyone else complains.
It was a test and I posted my result. _________________
Mahogany, 13 inches, pliable, excellent for Transfiguration.
Core: Unicorn hair from tail
Mahogany is known to be excellent for transfiguration and makes a great tool for warding off the Dark Arts.
Wands similar to yours: James Potter possessed a Mahogany wand, 11 inches
Resurrection Mary _________________ how tough am i? well, i'll have you know i stubbed my toe last week (while watering my spice garden), and i only cried for 20 minutes!
"Isaiah 41:10 Don't be afraid, for i am with you.Do not be dismayed, for i am your God. I will strengthen you. I will help you." _________________ yes, it is true i am in love with 78dlsjhs....and he proposed we are getting married!!!!
Growing up is mandartory, maturing is optionalDo you believe in magic?
join my forum [url]peterpanforums.7forum.info[/url]
update tlorder tlo
set tlo.job_id = (select tld.job_id from job_update tld
where tld.detail_line_id = tlo.detail_line_id
and tld.job_id is not null) where tlo.job_id is null@
update tlorder tlo
set tlo.job_detail_id = (select tld.job_detail_id from job_update tld
where tld.detail_line_id = tlo.detail_line_id
and tld.job_id is not null) where tlo.job_detail_id is null@
update tlorder tlo
set tlo.customer = (select jq.bill_to_code from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.callname = (select jq.bill_to_name from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.calladdr1 = (select jq.bill_to_add1 from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.calladdr2 = (select jq.bill_to_add2 from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.callcity = (select jq.bill_to_city from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.callprov = (select jq.bill_to_prov from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.callpc = (select jq.bill_to_pc from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.bill_to_code = (select jq.bill_to_code from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.bill_to_name = (select jq.bill_to_name from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.currency_code = (select jq.currency from job_master jq
where jq.job_id = tlo.job_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder tlo
set tlo.requested_equipmen = (select jd.eq_type from job_detail jd
where jd.job_detail_id = tlo.job_detail_id
) where tlo.job_detail_id is not null and tlo.current_status in ('COMPLETE','E','EDIT','HOLD') AND TLO.DETAIL_LINE_ID IN (SELECT DETAIL_LINE_ID FROM JOB_UPDATE)@
update tlorder set callname = ' ' where callname is null and CURRENT_STATUS IN ('ASSGN','CHECKIN','COMPLETE','DELVD','DISP','DOCKED','DONE','DSPSLT','LATE','LOADED','PHNCHK','PICKD','PLANASSGN','PLANNED','PREDISP','RAIN','RATES','RESCHED','SPTLD','WORKING','HOLD','OFFHOLD')@
update tlorder set origname = ' ' where origname is null and CURRENT_STATUS IN ('ASSGN','CHECKIN','COMPLETE','DELVD','DISP','DOCKED','DONE','DSPSLT','LATE','LOADED','PHNCHK','PICKD','PLANASSGN','PLANNED','PREDISP','RAIN','RATES','RESCHED','SPTLD','WORKING','HOLD','OFFHOLD')@
update tlorder set destname = ' ' where destname is null and CURRENT_STATUS IN ('ASSGN','CHECKIN','COMPLETE','DELVD','DISP','DOCKED','DONE','DSPSLT','LATE','LOADED','PHNCHK','PICKD','PLANASSGN','PLANNED','PREDISP','RAIN','RATES','RESCHED','SPTLD','WORKING','HOLD','OFFHOLD')@
update tlorder set requested_equipmen = ' ' where requested_equipmen is null and CURRENT_STATUS IN ('ASSGN','CHECKIN','COMPLETE','DELVD','DISP','DOCKED','DONE','DSPSLT','LATE','LOADED','PHNCHK','PICKD','PLANASSGN','PLANNED','PREDISP','RAIN','RATES','RESCHED','SPTLD','WORKING','HOLD','OFFHOLD')@
update tlorder set commodity = ' ' where commodity is null and CURRENT_STATUS IN ('ASSGN','CHECKIN','COMPLETE','DELVD','DISP','DOCKED','DONE','DSPSLT','LATE','LOADED','PHNCHK','PICKD','PLANASSGN','PLANNED','PREDISP','RAIN','RATES','RESCHED','SPTLD','WORKING','HOLD','OFFHOLD')@
INSERT INTO RPT_CUR_EQ_STAT
SELECT CAST('TR' AS VARCHAR(2)) TYPE, DATE(CURRENT DATE) DATE, TRAILER_ID UNIT, STATUS FROM TRAILER
WHERE STATUS IN ('OFS','RESERVE') and active_in_disp = 'True'@
INSERT INTO RPT_CUR_EQ_STAT
SELECT CAST('PU' AS VARCHAR(2)) TYPE, DATE(CURRENT DATE) DATE, UNIT_ID UNIT, STATUS FROM PUNIT
WHERE STATUS IN ('OFS','RESERVE') and active_where != 'D'@
update punit set status = 'AVAIL' where status = 'ASSGN' and unit_id not in (select unit_id from itrippun where trip_number in (select trip_number from trip where active_rec = 'True' ) )@
update trailer set status = 'AVAIL' where status = 'ASSGN' and trailer_id not in (select trailer_id from itriptra where trip_number in (select trip_number from trip where active_rec = 'True' ))@
UPDATE driverpay
SET leg_date = ( SELECT dpay_ahu.pick_up_by
FROM dpay_ahu
WHERE driverpay.detail_line_id = dpay_ahu.detail_line_id)
WHERE EXISTS
( SELECT dpay_ahu.pick_up_by
FROM dpay_ahu
WHERE driverpay.detail_line_id = dpay_ahu.detail_line_id)@
update drv_rule_jq set use_order_currency = 'True' where use_order_currency != 'True'@ _________________ how tough am i? well, i'll have you know i stubbed my toe last week (while watering my spice garden), and i only cried for 20 minutes!
kentucky _________________ yes, it is true i am in love with 78dlsjhs....and he proposed we are getting married!!!!
Growing up is mandartory, maturing is optionalDo you believe in magic?
join my forum [url]peterpanforums.7forum.info[/url]
Rules
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in
^
Do you believe in magic?