http://in.compucrete.com/index.php?action=history&feed=atom&title=Projected_Load_Analysis_for_Demand_Graph
Projected Load Analysis for Demand Graph - Revision history
2026-05-15T16:57:00Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Projected_Load_Analysis_for_Demand_Graph&diff=518&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T13:00:35Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-517:rev-518 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Projected_Load_Analysis_for_Demand_Graph&diff=517&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:02:10Z
<p>1 revision imported</p>
<p><b>New page</b></p><div><br />
== Simple Analysis ==<br />
Simple Project Load Query:<br />
<br />
<PRE><br />
select * from ditprjld<br />
where tgt_depart_dt between :sched_date and 1+:sched_date<br />
</PRE><br />
<br />
<br />
Simple Demand Graph Procedure Query:<br />
<PRE><br />
select * from dip_truckdemand(:Schedule_Date,1+:Schedule_Date,.25+:Schedule_Date)<br />
</PRE><br />
NOTE: Assumes 6 a.m. as current time.<br />
<br />
<br />
== Advanced Analysis ==<br />
<br />
<PRE><br />
select <br />
l.plant_no,o.will_call_flag,tgt_depart_dt Dept_Return_dt,1 "Change",o.cust_no,o.order_code,load_no,cast(tgt_depart_dt as time) Depart,cast(tgt_return_dt as time) Return,floor(.5+(tgt_return_dt-tgt_depart_dt)*1440) Time_Out_Min from ditprjld l<br />
inner join artordhd o on l.order_session_no=o.session_no and l.order_trans_no=o.trans_no<br />
where cast(tgt_depart_dt as date)=:Demand_Date<br />
union<br />
select <br />
l.plant_no,o.will_call_flag,tgt_return_dt Dept_Return_dt,-1 "Change",o.cust_no,o.order_code,load_no,cast(tgt_depart_dt as time) Depart,cast(tgt_return_dt as time) Return,floor(.5+(tgt_return_dt-tgt_depart_dt)*1440) Time_Out_Min from ditprjld l<br />
inner join artordhd o on l.order_session_no=o.session_no and l.order_trans_no=o.trans_no<br />
where cast(tgt_depart_dt as date)=:Demand_Date<br />
</PRE></div>
Intra>User